View previous topic :: View next topic
|
Author |
Message |
babu_hi
New User
Joined: 11 Apr 2006 Posts: 93
|
|
|
|
i am getting error,when i submit bind jcl i got -206 error.
i have declared cursor like this,
DECLARE CONTROL_TABLE_CSR CURSOR FOR
SELECT CNTL_TBL_NME,
CNTL_DTE,
CNTL_FLAG
FROM ARW_CNTL_TABLE
WHERE CNTL_FLAG = 'A' OR CNTL_FLAG = 'H' AND
CNTL_DTE BETWEEN WS-START-DATE AND WS-CURRENT-DATE
ORDER BY CNTL_DTE DESC
please look for bind error information
DSNX200I - BIND SQL ERROR
USING ARW01D AUTHORITY
PLAN=(NOT APPLICABLE)
DBRM=ARWFTB
STATEMENT=82
SQLCODE=-206
SQLSTATE=42703
TOKENS=WS-START-DATE
CSECT NAME=DSNXORSO
RDS CODE=-100
DSNT233I - UNSUCCESSFUL BIND FOR
PACKAGE = DSN0S.ARWCB0.ARWFTB.()
please tell me the solution for this? |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
Code: |
CNTL_DTE BETWEEN WS-START-DATE AND WS-CURRENT-DATE |
You need a colon : to identify the host variables
Code: |
CNTL_DTE BETWEEN :WS-START-DATE AND :WS-CURRENT-DATE |
|
|
Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
babu,
change ur cursor declaration as
Code: |
BETWEEN :WS-START-DATE AND :WS-CURRENT-DATE
|
these are host variables |
|
Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
oops sorry craq ... i didnt c ur post ... |
|
Back to top |
|
|
babu_hi
New User
Joined: 11 Apr 2006 Posts: 93
|
|
|
|
if tried with :(colon)..but i am getting compilation error,
DSNH312I E DSNHSMUD LINE 88 COL 36 UNDEFINED OR UNUSABLE HOST VARIABLE
DSNH312I E DSNHSMUD LINE 88 COL 55 UNDEFINED OR UNUSABLE HOST VARIABLE
Thanks
babu |
|
Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
Did you define WS-START-DATE and WS-CURRENT-DATE in WS ? |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
What are the definitions of ws-start-date and ws-current-date? |
|
Back to top |
|
|
babu_hi
New User
Joined: 11 Apr 2006 Posts: 93
|
|
|
|
Yes..i have declared both variables in working storage section,
05 WS-START-DATE PIC 9(06) VALUE ZEROS.
05 WS-CURRENT-DATE PIC 9(06) VALUE ZEROS.
and i have modified the cursor declaration as per Craq Giegerich post reply,
EXEC SQL
DECLARE CONTROL_TABLE_CSR CURSOR FOR
SELECT CNTL_TBL_NME,
CNTL_DTE,
CNTL_FLAG
FROM ARW_CNTL_TABLE
WHERE CNTL_FLAG = 'A' OR CNTL_FLAG = 'H'
AND (CNTL_DTE BETWEEN :WS-START-DATE AND :WS-CURRENT-DATE)
ORDER BY CNTL_DTE DESC
END-EXEC.
and still i am getting same error,
DSNH312I E DSNHSMUD LINE 88 COL 37 UNDEFINED OR UNUSABLE HOST VARIABLE "WS-START-DATE"
DSNH312I E DSNHSMUD LINE 88 COL 56 UNDEFINED OR UNUSABLE HOST VARIABLE "WS-CURRENT-DATE" .
How do i solve this problem,plz privide solution? |
|
Back to top |
|
|
babu_hi
New User
Joined: 11 Apr 2006 Posts: 93
|
|
|
|
problem got solved with change of pic clause..
Thanks for your valuble reply's |
|
Back to top |
|
|
|