| View previous topic :: View next topic |
| Author |
Message |
kirank
Beginner
Joined: 21 Apr 2004
Posts: 61
Topics: 33
Location: hyderabad
|
 Posted: Sat May 02, 2015 6:43 am Post subject: Passing values in where condition of db2 query |
 |
|
| Hi I've a file contains three fields like field1 field2 field3. This file contains multiple records. I want to delete rows from a db2 table if the values present in the table. I know the fields of the table . Example Delete from table where f1 = field1 and f2 = field2 and f3 = field3. This query should be executed thru JCL. Can anyone please help. Thank you |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose
|
| Posted: Sun May 03, 2015 12:55 am Post subject: Re: Passing values in where condition of db2 query |
|
|
| kirank wrote: | | Hi I've a file contains three fields like field1 field2 field3. This file contains multiple records. I want to delete rows from a db2 table if the values present in the table. I know the fields of the table . Example Delete from table where f1 = field1 and f2 = field2 and f3 = field3. This query should be executed thru JCL. Can anyone please help. Thank you |
Kirank,
You can generate SQL control cards reading an input file using DFSORT. However you should know that you can only 409 records as the maximum length of a sql that can be read is 32760. So what would you do if you had more than 409 records?
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
