View previous topic :: View next topic
|
Author |
Message |
santosh100678
New User
Joined: 21 Sep 2009 Posts: 55 Location: Kolkatta
|
|
|
|
Hi,
I have try to take input file and insert data of input file in db2 table where some db2 column are varchar also.
you mention in your query about select statement
Select * from users where clue > 0
SQLstate=02000
could you please telll about how i insert data in db2 table by using input as a file throu jcl. |
|
Back to top |
|
|
rexzone1
New User
Joined: 16 Dec 2006 Posts: 14 Location: Halifax, Canada
|
|
|
|
Hi Satish,
Please search the DB2 forum before asking queries.
I found the below link on how to load the data using a flat file.
<http://ibmmainframes.com/viewtopic.php?t=42246&highlight=load>
Try this out and then let us know for any issues.
Hope this helps. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
santosh100678 wrote: |
you mention in your query about select statement
Select * from users where clue > 0
SQLstate=02000 |
GuyC would be amazed on your though process...LOL. |
|
Back to top |
|
|
|