MVSFORUMS.com

mcclr · Beginner Joined: 10 Jan 2006 Posts: 11 Topics: 4

We are reading in a file that contains 10 bytes of data that is all numeric in column 1. We are using DSNREXX to issue a DB2 select statement with this variable in the WHERE clause.
SELECT NAME FROM TABLE1 WHERE KEY = "inputfield"
KEY is defined in the table as a 10 byte character field. The datatype of the variable that Rexx creates is numeric. This causes the select to receive a -301 SQL error. Is there a way to cause the 'inputfield' in Rexx to be character instead of numeric?
Thanks, Larry

kolusu · Posted: Tue Jul 24, 2007 2:08 pm Post subject:

mcclr,

when you say NUMERIC is the data left justified ? ie.

mcclr · Beginner Joined: 10 Jan 2006 Posts: 11 Topics: 4

Kolusu,
Not necessarily. It seems to create a numeric variable whether it is left justified or not.
Example:

dbzTHEdinosauer · Posted: Tue Jul 24, 2007 3:30 pm Post subject:

you can use BBcode to preserve your spacing - creates CODE blocks

could try

characters_for_sql = FORMAT(char_pos_1_to_10,10)
_________________
Dick Brenholtz
American living in Varel, Germany

s_shivaraj · Posted: Tue Jul 24, 2007 3:41 pm Post subject:

mcclr,

expat · Posted: Wed Jul 25, 2007 2:40 am Post subject:

Deleted, erroneous reply posted

dbzTHEdinosauer · Posted: Wed Jul 25, 2007 3:28 am Post subject:

s_shivaraj,

good thinking, great post!
_________________
Dick Brenholtz
American living in Varel, Germany