Function in Basic Language

SUMAN CHILUVURI · Post by **SUMAN CHILUVURI** » Fri Mar 15, 2013 9:11 am

Is there function in datastage basic language which is used to make the job wait for 10 minutes and then run

chulett · Post by **chulett** » Fri Mar 15, 2013 9:22 am

I seem to recall a SLEEP or NAP function or you could do the same thing at the command line via ExecSH. Do it before job and the job will "start" but not process anything on the canvas until the sleep ends.

priyadarshikunal · Post by **priyadarshikunal** » Fri Mar 15, 2013 9:42 am

chulett wrote:I seem to recall a SLEEP or NAP function

Both statements are present in basic. Sleep statement takes number of seconds however NAP takes it in milliseconds.

ray.wurlod · Post by **ray.wurlod** » Fri Mar 15, 2013 3:35 pm

SLEEP takes either seconds or a time in HH:MM format. So SLEEP 13:45 will sleep until 1:45pm. If it is already after that time, no sleep will occur.