View previous topic :: View next topic |
Author |
Message |
prabhutp Beginner
Joined: 02 Feb 2005 Posts: 20 Topics: 11
|
Posted: Fri Jan 06, 2006 1:34 pm Post subject: DB2 Query ? |
|
|
Hi
In my table the field is X(220)...It is passed into an array..with group variable as
A X(01)
B 9(02)
C S9(15) COMP-3.
Now..can u pls let me know..which format I should enter the numeric variables. Should it be 8 numbers ? _________________ tp |
|
Back to top |
|
|
SureshKumar Intermediate
Joined: 23 Jan 2003 Posts: 211 Topics: 21
|
Posted: Fri Jan 06, 2006 2:40 pm Post subject: |
|
|
prabhutp,
It depends on how you intend to use it. If you store it as number in the table, then you need to map it to a numeric variable and then load it to the Comp field else if you store it in comp format in the table then you can map it directly. Explain you requirement clearly. Thanks |
|
Back to top |
|
|
prabhutp Beginner
Joined: 02 Feb 2005 Posts: 20 Topics: 11
|
Posted: Mon Jan 09, 2006 4:30 am Post subject: |
|
|
Hi
Thanks for the reply. I need to map it to X(220) from table...which will be then defined as X(01), 9(02) and S9(15) comp-3. Hence should it be in Alphanumeric format in the table ?? _________________ tp |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
|
Posted: Mon Jan 09, 2006 5:47 am Post subject: |
|
|
prabhutp, Quote: |
Hence should it be in Alphanumeric format in the table ??
|
YES _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
|
|