View previous topic :: View next topic
|
Author |
Message |
deva
New User
Joined: 03 Nov 2005 Posts: 19
|
|
|
|
Hi All
Facing bind problem when using host variable in SUBSTR giving -206
In below query WS-VAR is hostvariable,but it is not a column name of table XYZ, I am moving value to WS-VAR based on my input which is from flat file.
I am using STATIC SQL. Is it possible to do like below with static SQL, If it is possible help me with some sample program and DCLGEN also
SELECT STATE
INTO :WS-ST
FROM XYZ
WHERE SUBSTR(STATE,:WS-VAR,2) = :A
AND B = :B
AND C = :C
Thanks In advance
Deva... |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
deva wrote: |
Hi All
Facing bind problem when using host variable in SUBSTR giving -206
In below query WS-VAR is hostvariable,but it is not a column name of table XYZ, I am moving value to WS-VAR based on my input which is from flat file.
I am using STATIC SQL. Is it possible to do like below with static SQL, If it is possible help me with some sample program and DCLGEN also
SELECT STATE
INTO :WS-ST
FROM XYZ
WHERE SUBSTR(STATE,:WS-VAR,2) = :A
AND B = :B
AND C = :C
Thanks In advance
Deva... |
How is STATE defined and how is ws-var defined. |
|
Back to top |
|
|
deva
New User
Joined: 03 Nov 2005 Posts: 19
|
|
|
|
STATE is table column,WS-STAT as CHAR, WS-VAR considered as CHAR |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
deva wrote: |
STATE is table column,WS-STAT as CHAR, WS-VAR considered as CHAR |
Where you are using ws-var in the sql an integer is required. |
|
Back to top |
|
|
deva
New User
Joined: 03 Nov 2005 Posts: 19
|
|
|
|
In working storage section..
01 WS-VAR PIC 99.
01 WS-FIELDS.
05 WS-ST PIC XX.
In my program I am not using any DCLGEN. my main intension is can we able to pass value to host variable in substring. I am able to do this with dyanmic SQL, but which is expensive.
So I am looking for STATIC sql solution. |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
deva wrote: |
In working storage section..
01 WS-VAR PIC 99.
01 WS-FIELDS.
05 WS-ST PIC XX.
In my program I am not using any DCLGEN. my main intension is can we able to pass value to host variable in substring. I am able to do this with dyanmic SQL, but which is expensive.
So I am looking for STATIC sql solution. |
I am not sure if you can do it or not. ws-var pic s9(9) comp might work or
WHERE STRPOS(STATE, :A) = :WS-VAR again with ws-var defined as comp might work. |
|
Back to top |
|
|
deva
New User
Joined: 03 Nov 2005 Posts: 19
|
|
|
|
Hey Craq Now I am able to bind..Need to check my data
Thanks a lot for your help.
Deva... |
|
Back to top |
|
|
|