How to SUBSTR a group variable in a table using REXX/DB2

vasan_4u · New User Joined: 28 Jun 2005 Posts: 35 Location: chennai

i am coding a REXX routine in which i have to select a variable which is in a group varaible this how the grp variable is

12 BOR-NM-GRP-TXT PIC X(29).
12 BOR-REDFD-NM-TXT REDEFINES BOR-NM-GRP-TXT.
15 BOR-LST-NM PIC X(16).
15 BOR-1ST-NM PIC X(12).
15 BOR-MI-NM PIC X.

i have to select BOR-LST-NM alone in the rexx program

this is the code i have written

SQL1 = "SELECT SUBSTR ('BOR_NM_GRP_TXT',1,16)",
"FROM" db ".lsbor where bor_ssn = "ssn

now when i prepare this select stmt it shows me a -138 sqlcode ...

how should i select this txt

please let me know

ofer71 · Posted: Tue Aug 29, 2006 7:22 pm

Why did you put quotes around 'BOR_NM_GRP_TXT' ?

O.

vasan_4u · New User Joined: 28 Jun 2005 Posts: 35 Location: chennai