MVSFORUMS.com

naren_ab · Beginner Joined: 07 Jan 2003 Posts: 32 Topics: 10

Need help in resloving this error.

****** SP START*****2003091809403858-0400
@ CHECK-PASSED-PARAMS.
STRING "SELECT C1"
",C2"
",C3"
",C4"
",C5"
",C6"
",C7"
",C8"
",C9"
",C10"
",C11"
",C12"
",C13"
",C14"
"FROM ADMIN.TBNAME
" WHERE C1 >= '" WS-C1(1:2) "' "
" ORDER BY C1 ASC "
DELIMITED BY SIZE
INTO WS-SQL-TXT
END-STRING.

EXEC SQL PREPARE
SEARCH_SQL FROM :WS-DYNAM-SQL
END-EXEC.
Evaluate SQLCODE
******** DATE/TIME: 09/18/2003-09:40:38.86
SQLERR: -104 PROGRAM: TEST PARAGRAPH:

ADDITIONAL PGMR INFO: UNEXPECTED ERROR PREPARING SELECT SQL

DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL " ". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: , FOR WITH FETCH QUERYNO OPTIMIZE
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 0 0 0 -1 263 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF' X'00000107' X'00000000' SQL DIAGNOSTIC INFORMATION
******** DATE/TIME: 09/18/2003-09:40:38.86 ******SP END

Bithead · Posted: Thu Sep 18, 2003 10:08 am Post subject:

You need to set the length of teh statement:

01 WS-DYNAM-SQL.
05 WS-SQL-LEN PIC S9(4) COMP.
05 WS-SQL-TXT PIC ...

01 SQL-POINTER PIC S9(4) COMP.

STRING ....
INTO WS-SQL-TXT
POINTER SQL-POINTER
END-STRING.

MOVE SQL-POINTER TO WS-SQL-LEN.

kolusu · Posted: Thu Sep 18, 2003 10:12 am Post subject:

Naren,

IS your ws-dynam-sql defined like this ?

naren_ab · Beginner Joined: 07 Jan 2003 Posts: 32 Topics: 10

Good morning Bithead and Kolusu,

Thanks for all the help, i found out with the ideas you gave me..
Bithead, I had the definition of ws-dynam-sql the way Kolusu mentioned and DELIMITED BY SIZE will equalize POINTER for my purpose.
Kolusu, i am populating the length field before the prepare.

When i do normal compute to get the length it was the length from the declaration of PIC clause. but not the real length of text. And more over i have defined the TEXT and LENGTH field, which gets moved into ws-dynam-sql wrongly. So it was always thinking that there should be some thing to end the statement.

But thanks for all the help. This was my first dynam SQL, though i know how it works all the internals, but newer tried it till now and the rest is same as static sql program.

You both have great day.

kolusu · Posted: Tue Sep 23, 2003 8:55 am Post subject:

Naren,
Glad I was able to help.

naren_ab · Beginner Joined: 07 Jan 2003 Posts: 32 Topics: 10

Hi Morning,

Kolusu, i used SYSDUMMY1 to calculate the length. So squared that problem using existing variables.