| View previous topic :: View next topic |
| Author |
Message |
manojagrawal
Beginner
Joined: 25 Feb 2003
Posts: 124
Topics: 29
|
 Posted: Thu Mar 27, 2003 8:34 am Post subject: Where Clause in GU/GN Calls |
 |
|
Hi,
If i have an EXEC DLI GU/GN call, can i use the following WHERE Clause.
| Code: | | WHERE (Substr(Fieldname,5,3) = ' ') |
The entire command would be
| Code: | | EXEC DLI USING PCB(2) SEGMENT(SEGNAME) WHERE (SUBSTR(FIELDNAME,5,3) = ' ') INTO(IN_REC); |
Fieldname is the name of the Field as defined in the DBD and is the Key.
Regards,
Manoj. |
|
| Back to top |
|
 |
vasanthrs
Beginner
Joined: 18 Dec 2003
Posts: 2
Topics: 0
|
| Posted: Thu Dec 18, 2003 5:39 am Post subject: |
|
|
Hi Manoj 
Hope you can't use Where clause in DL/I calls.
What you can do is like you retrieve the data from the database using a GU/GN call and move it to some variable.
after that you can the substring.
Hope this will help you.
Thanks,
_________________
Vasanth. |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Thu Dec 18, 2003 6:25 am Post subject: |
|
|
manojagrawal,
As Vasanth mentioned IMS is not that flexible like DB2. You need to retrieve the record and then compare the record using reference modification.
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
Bithead
Advanced
Joined: 03 Jan 2003
Posts: 550
Topics: 23
Location: Michigan, USA
|
| Posted: Thu Dec 18, 2003 11:13 am Post subject: |
|
|
| IMS has search fields which can be used to select specific segments. They have to be defined to the DBD so you can't just pick any data on the segment. The search field criteria is defined in your SSA. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
