calling a script
Posted: Mon Oct 04, 2004 6:19 pm
Hi, I new to DS, anybody help me with solution for this,
I have source coming from text file and DB2 table. target is DB2 table. I have straight move from text file, but from DB2 table I need to get only one column which is date, I need to get latest date from it, these two sources( text file and DB2 table) have none of the columns same. How can I do it, do I need to write a shell script with sql inside and call it(script) somewhere. help me here.
forboy
I have source coming from text file and DB2 table. target is DB2 table. I have straight move from text file, but from DB2 table I need to get only one column which is date, I need to get latest date from it, these two sources( text file and DB2 table) have none of the columns same. How can I do it, do I need to write a shell script with sql inside and call it(script) somewhere. help me here.
forboy