Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Facing bind problem when using host variable in SUBSTR

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
deva

New User


Joined: 03 Nov 2005
Posts: 19

PostPosted: Tue Oct 30, 2007 7:28 pm    Post subject: Facing bind problem when using host variable in SUBSTR
Reply with quote

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
View user's profile Send private message

Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Tue Oct 30, 2007 7:35 pm    Post subject: Re: Facing bind problem when using host variable in SUBSTR
Reply with quote

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
View user's profile Send private message
deva

New User


Joined: 03 Nov 2005
Posts: 19

PostPosted: Tue Oct 30, 2007 8:44 pm    Post subject: Reply to: Facing bind problem when using host variable in SU
Reply with quote

STATE is table column,WS-STAT as CHAR, WS-VAR considered as CHAR
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Tue Oct 30, 2007 8:55 pm    Post subject: Re: Reply to: Facing bind problem when using host variable i
Reply with quote

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
View user's profile Send private message
deva

New User


Joined: 03 Nov 2005
Posts: 19

PostPosted: Tue Oct 30, 2007 9:44 pm    Post subject: Reply to: Facing bind problem when using host variable in SU
Reply with quote

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
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Tue Oct 30, 2007 10:04 pm    Post subject: Re: Reply to: Facing bind problem when using host variable i
Reply with quote

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
View user's profile Send private message
deva

New User


Joined: 03 Nov 2005
Posts: 19

PostPosted: Tue Oct 30, 2007 10:18 pm    Post subject: Reply to: Facing bind problem when using host variable in SU
Reply with quote

Hey Craq Now I am able to bind..Need to check my data

Thanks a lot for your help.
Deva...
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SYMNAMES problem jacobdng DFSORT/ICETOOL 7 Thu Dec 22, 2016 7:47 am
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm
No new posts DB2 Streaming Batch Processing Problem Manshadi DB2 4 Sat Sep 24, 2016 12:14 pm
No new posts Format to pipe delimited with variabl... pshongal SYNCSORT 6 Wed Sep 14, 2016 2:48 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us