CA Ideal Commands › SET DBSQL Command (CA Datacom SQL Access)

SET DBSQL Command (CA Datacom SQL Access)

This command establishes default options for CA Datacom/DB access plans. These options are defaults used for creating new program environment components. Changing these options has no effect on programs already created. You can override these options before compiling a program using the program's environment fill‑in or before rebinding a compiled program using the ALTER PROGRAM ENVIRONMENT command.

This command has the following format:

                  {      AUTH auth‑id          }
                  {                            }
                  {      CBSIO nnnnnn          }
                  {                            }
                  {            { DB  }         }
                  {            { ISO }         }
                  {      DATE  { USA }         }
                  {            { EUR }         }
                  {            { JIS }         }
                  {                            }
                  {           { P }            }
                  {  DECPOINT { C }            }
                  {                            }
                  {                  { CS }    }
                  {  ISOLATION LEVEL { R  }    }
                  {                  { U  }    }
                  {                            }
SET [SITE] DBSQL  {        { ANSI86  }         }
                  {  MODE  { Datacom }         }
                  {        { FIPS    }         }
                  {                            }
                  {  OPTMODE optmode           }
                  {                            }
                  {           {      { NON }}  }
                  {  OPTMSGS  { PREP { DET }}  }
                  {           { EXEC { SUM }}  }
                  {  PRIORITY nn               }
                  {           { A }            }
                  {  STRDELIM { Q }            ]
                  {                            }
                  {        { DB  }             }
                  {        { ISO }             }
                  {  TIME  { USA }             }
                  {        { EUR }             }
                  {        { JIS }             }
                  {                            }
                  {           { SEC }          }
                  {  WAIT nnn { MIN }          }