DSXchange

if your lookup condition does not match from reference with stream, you have that issue, please check the values in keys are matching to get output.

[quote="sachin1"]to get message for empty file before ftp operation, you can create custom routine to check for file size and log the message, abort operation or continue operation, routine to be used in before job subroutine

to get message for empty file before ftp operation, you can create custom routine to check for file size and log the message, abort operation or continue operation.

please check for value of parameters defined for sequencer.

Please let us know when you want to track for empty file before ftp or after ftp operation.

yes using dsjob command, searching forum can help you.

hello please try this, may be some more efficient methods are also available for first day of next month for your input oconv( ( MONTH.first(MONTH.TAG(ICONV("20080831","DYMD") + 1))),"D-YMD[4,2,2]").---->2008-09-01 for last day of month for given input oconv( ( MONTH.LA...

hello,
please try this

Oconv(@DATE, "D-YMD[4,2,2]"):' ':Oconv(@time, "MTS")

where you want to execute these commands, i mean before/afte job subroutine or in basic code.

OCONV(ICONV(ereplace("19-SEP-08","-"," "),"D2"),"D YMD[4,2,2]"), so when your input is "19-SEP-08" output is 2008 09 19, taking your oconv format into account.

please let us know the input format of date, give an example of your input date.

yes you can do it.............just go to job control tab in JOB-PROPERTIES, you will have a drop down list of jobs and sequences, you add your sequence and run your job.
the job will call your sequence and then finish itself.

please elaborate what you want to achieve, may be you need to custom code in JOB-Control tab.

Never tried but please check for help in datastage for Sleep

[/b]

myukassign wrote:Can I pass job parameters as the parameter value in this function?

YES