View previous topic :: View next topic |
Author |
Message |
balu_ver2k2 Beginner
Joined: 29 Jan 2016 Posts: 2 Topics: 1
|
Posted: Sat Jul 16, 2016 8:11 am Post subject: Easytrieve + DB2 |
|
|
Hi,
I am looking for easytrieve code for below requirements
File Input of length 10
ColA
AAAAA
BBBBB
CCCC
Output file of length 10
Col A Col B
AAAAA 1111
BBBBB 2222
CCC 3333
Looking for Easyrtive to read file and query DB2 and write in to o/p file
sample query
Select COLB from table where COLA =?
THank you |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
|
|
Back to top |
|
|
balu_ver2k2 Beginner
Joined: 29 Jan 2016 Posts: 2 Topics: 1
|
Posted: Sun Jul 17, 2016 2:03 am Post subject: reply |
|
|
Thank You Kolusu. I did see the topic hence I have used the same subject for my reference. Do you mind to share how to input file is read and passed to SQL ? |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
|
Posted: Sun Jul 17, 2016 9:04 am Post subject: Re: reply |
|
|
balu_ver2k2 wrote: | Thank You Kolusu. I did see the topic hence I have used the same subject for my reference. Do you mind to share how to input file is read and passed to SQL ? |
Huh? Did you even read the above given topic? Pay attention to FILE INFILE in the example and you should see how the input file is used. All you need to do is add a couple of working storage variables and define your OUTPUT file _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
|
|