DSXchange

Hi Actually i have two machines namely project1 and project2 .In both systems Datastage7.5.2 server is installed. Both machines have been connected by TCP/IP protocol.I have created a config like { node "node1" { fastname "PROJECT1" pools "" resource disk "C:/Ascen...

Krazykoolrohit wrote:can you check at the table level, if there is any restriction or preprocessing involved with this field

No, There is no restriction or preprocessing involved with this field. Simply Load the date fiels as 'date' and Read it as 'date'.

its ok that there is no harm in using as char, i want to know the reason of this problem, why it is not properly resulting in case of using 'date'

hi

i looking at correct dataset only Raghavendra..

If i read it as a varchar or Char, it gives a correct date, When i read it as a Date then only this this issue.

Hi Raghavendra

No., i just extract the data from db2 database using DB2/UDB Stage and simply loaded into Dataset. There is no transformer stage like.

hi tagnihotri

Date in Database as 2000-10-12

When i view from DB2/UDB Stage Date is 2000-10-12 only

But after running the job if i view the same record in Dataset the Date is coming like 2000-10-11.

Thanks and Advanced Thanks
Ragunathan J

hi All.. I read records from DB2 using DB2/UDB stage and loaded into Dataset. In this some Date fields are there. When i view the records from DB2\UDB stage i got actual date present in database. But when the same records are viewed in Dataset stage the dates are existing in the previous day's date....

hi chulett

Actually my requirement is read the "jobnames" from db2 table one by one and run those jobs sequentially using routine.

Thanks and regards
Ragunathan J

what is u'r source....

it's a sequential file or any other

hi kumar

yes... but i don't know how to connect with db2..

can u give some sample code for this pl...

Regards
Ragunatha J

hi kumar..

actually my req. is, using routines i have to extract the records from db2 table

Regards
Ragunathan J

Hi to all,
Can anybody tell how to get the records from DB2 table through routines?
if possible, pls send the routine.

Advanced Thanks.
Ragunathan J.