+ Reply to Thread
Page 1 of 3 1 2 3 LastLast
Results 1 to 10 of 22

sqlcode -901 sqlstate 58004

  1. sqlcode -901 sqlstate 58004

    sqlcode -901 sqlstate 58004
    i get this error when i do the following

    1. strqm (works ok)
    2. f12 (ok still)
    3. strqm

    when i have commitment control set to *chg this i can't run sql
    statements in strsql .
    how do i check sql system settings or does anyone know what causes this
    ?

    thanking all in advance.
    Garreth


  2. Re: sqlcode -901 sqlstate 58004

    garrethkelly wrote:
    > sqlcode -901 sqlstate 58004
    > i get this error when i do the following
    >
    > 1. strqm (works ok)
    > 2. f12 (ok still)
    > 3. strqm
    >
    > when i have commitment control set to *chg this i can't run sql
    > statements in strsql .
    > how do i check sql system settings or does anyone know what causes this
    > ?
    >
    > thanking all in advance.
    > Garreth
    >

    For -901 call support. I this DB2 for zOS or iSeries btw?

    Cheers
    Serge
    --
    Serge Rielau
    DB2 SQL Compiler Development
    IBM Toronto Lab

  3. Re: sqlcode -901 sqlstate 58004

    garrethkelly wrote:
    > sqlcode -901 sqlstate 58004
    > i get this error when i do the following
    >
    > 1. strqm (works ok)
    > 2. f12 (ok still)
    > 3. strqm
    >
    > when i have commitment control set to *chg this i can't run sql
    > statements in strsql .
    > how do i check sql system settings or does anyone know what causes this
    > ?
    >
    > thanking all in advance.
    > Garreth
    >

    For -901 call support. I this DB2 for zOS or iSeries btw?

    Cheers
    Serge
    --
    Serge Rielau
    DB2 SQL Compiler Development
    IBM Toronto Lab

  4. Re: sqlcode -901 sqlstate 58004

    garrethkelly wrote:
    > sqlcode -901 sqlstate 58004
    > i get this error when i do the following
    >
    > 1. strqm (works ok)
    > 2. f12 (ok still)
    > 3. strqm
    >
    > when i have commitment control set to *chg this i can't run sql
    > statements in strsql .
    > how do i check sql system settings or does anyone know what causes this
    > ?
    >
    > thanking all in advance.
    > Garreth
    >

    For -901 call support. I this DB2 for zOS or iSeries btw?

    Cheers
    Serge
    --
    Serge Rielau
    DB2 SQL Compiler Development
    IBM Toronto Lab

  5. Re: sqlcode -901 sqlstate 58004

    garrethkelly wrote:
    > sqlcode -901 sqlstate 58004
    > i get this error when i do the following
    >
    > 1. strqm (works ok)
    > 2. f12 (ok still)
    > 3. strqm
    >
    > when i have commitment control set to *chg this i can't run sql
    > statements in strsql .
    > how do i check sql system settings or does anyone know what causes this
    > ?
    >
    > thanking all in advance.
    > Garreth
    >

    For -901 call support. I this DB2 for zOS or iSeries btw?

    Cheers
    Serge
    --
    Serge Rielau
    DB2 SQL Compiler Development
    IBM Toronto Lab

  6. Re: sqlcode -901 sqlstate 58004

    garrethkelly wrote:
    > sqlcode -901 sqlstate 58004
    > i get this error when i do the following
    >
    > 1. strqm (works ok)
    > 2. f12 (ok still)
    > 3. strqm
    >
    > when i have commitment control set to *chg this i can't run sql
    > statements in strsql .
    > how do i check sql system settings or does anyone know what causes this
    > ?
    >
    > thanking all in advance.
    > Garreth
    >

    For -901 call support. I this DB2 for zOS or iSeries btw?

    Cheers
    Serge
    --
    Serge Rielau
    DB2 SQL Compiler Development
    IBM Toronto Lab

  7. Re: sqlcode -901 sqlstate 58004

    garrethkelly wrote:
    > sqlcode -901 sqlstate 58004
    > i get this error when i do the following
    >
    > 1. strqm (works ok)
    > 2. f12 (ok still)
    > 3. strqm
    >
    > when i have commitment control set to *chg this i can't run sql
    > statements in strsql .
    > how do i check sql system settings or does anyone know what causes this
    > ?
    >
    > thanking all in advance.
    > Garreth
    >

    For -901 call support. I this DB2 for zOS or iSeries btw?

    Cheers
    Serge
    --
    Serge Rielau
    DB2 SQL Compiler Development
    IBM Toronto Lab

  8. Re: sqlcode -901 sqlstate 58004

    garrethkelly wrote:
    > sqlcode -901 sqlstate 58004
    > i get this error when i do the following
    >
    > 1. strqm (works ok)
    > 2. f12 (ok still)
    > 3. strqm
    >
    > when i have commitment control set to *chg this i can't run sql
    > statements in strsql .
    > how do i check sql system settings or does anyone know what causes this
    > ?
    >
    > thanking all in advance.
    > Garreth
    >

    For -901 call support. I this DB2 for zOS or iSeries btw?

    Cheers
    Serge
    --
    Serge Rielau
    DB2 SQL Compiler Development
    IBM Toronto Lab

  9. Re: sqlcode -901 sqlstate 58004

    it is an iseries running v5r2 all the latest ptfs , if i take off the
    *chg using f13 everything is ok until i enable it again .if i use
    crtqmqry and then try to run strqmqry it also falls over with the error
    above no matter what i try .


  10. Re: sqlcode -901 sqlstate 58004

    it is an iseries running v5r2 all the latest ptfs , if i take off the
    *chg using f13 everything is ok until i enable it again .if i use
    crtqmqry and then try to run strqmqry it also falls over with the error
    above no matter what i try .


+ Reply to Thread
Page 1 of 3 1 2 3 LastLast