how do i check for the last updated datetime in a job

[bgs_vb]

Hi,

I need to check for last updated datetime of the table, for incremental upload.

Vindy

[ray.wurlod]

You've got whatever the database provides, and anything you design into DataStage. Research.

[bgs_vb]

I already have a job that checks using a routine the maxdatetime value, but it throws 'literal not in the format' error.

I tried like this :
say DtTime = '10-03-2006 08:15:25'
Dt = Left(Time, 10)
Tm = Right(DtTime, 12)
D1 = OCONV(ICONV(Dt, "D/DMY"), "D/MDY[2,2,4]")
T1 = OCONV(ICONV(Tm, "MTS"), "MTHS")

Ans = D1:" ":T1

when i test the output it from the routine it shows the date and time...but when i run it thru Director it throws error. also how do i initialize current server DateTime...is there any system variable available.

Advance thanks,

Vindy

[DeepakCorning]

Do you mean that you have last update time in the database and you want to use it to make the job incremental if yes then you can use it in the selection criteria ....
and if u mean that u want to assign the current run time information then you can use ds macros like DSJOBSTARTTIMESTAMP.

[chulett]

...is there any system variable available.

Check the online Help index for System Variables - they are there. You'll find things like @DATE and @TIME plus references to functions like Date(), Time() and TimeDate() off the top of my head. See which would work best for you.

[ray.wurlod]

I already have a job that checks using a routine the maxdatetime value, but it throws 'literal not in the format' error.

I tried like this :
say DtTime = '10-03-2006 08:15:25'
Dt = Left(Time, 10)
Tm = Right(DtTime, 12)
D1 = OCONV(ICONV(Dt, "D/DMY"), "D/MDY[2,2,4]")
T1 = OCONV(ICONV(Tm, "MTS"), "MTHS")

Ans = D1:" ":T1

when i test the output it from the routine it shows the date and time...but when i run it thru Director it throws error. also how do i initialize current server DateTime...is there any system variable available.

Advance thanks,

Vindy

Instead of Tm = Right(DtTime, 12) you need Tm = Right(DtTime, .
Only the rightmost 8 characters of the timestamp are the time component.