DSXchange

chulett wrote:What else do you need to do? There must be more than just calling this routine X times.

Either build a looping Sequence job as noted or create a new routine that can do whatever with mu ...

I am not getting you....

ArndW wrote:You should write a loop in a job sequence to expand that wildcard and call the routine within the loop. ...

Arul, can you help me to write this loop ?

chulett wrote:No. The routine reads a single file. ...

then How to achieve my requirement?

ArndW wrote:The routine will read the first line of the file specified in "FileName" and return that string. ...

I have files like

df_excp1.log
df_excp2.log
df_excp3.log

i want to get these file names. I used like

"df_excp*.log" in the value expression.

will it work out?

All, What this below routine will do? what is the purppose of this routine? RoutineName: InputFileList Argument Name: FileName *Ans = "" DFILE = TRIM(FileName) OPENSEQ DFILE TO F.DFILE THEN READSEQ REC FROM F.DFILE ELSE NULL Ans1 = REC Ans = 0 RETURN(Ans1) END ELSE * Could not open the fil...

Explain your job design - basically list the stages used and what role each is playing in the job. ... file1 | | sequential file --> transformer --> aggregation ---> file2 in the transformer , i wrote a constrain like iif fnd_cd <> 'C' then file1 f fnd_cd = 'C' then file2

datskosaraju wrote:You didn't give us your job design(flow) to find what's wrong!!!

what you are expecting? can you tell me? i am not gettting you.

I have also created an constraint saying if fnd_cd = 'C' then move it to file2
if fnd_cd <> 'C' then move it to file1.

All, I have created a job which will fetch data from a table and load it in two files. format: fund_id fnd_dt fund_cd qty price i will fetch the above information and store it in two file based on the below logic. 1) If fnd_cd = 'C' then i will aggregate it and store it in a file 2) if fnd_cd <> 'C'...

use a move command in ExecDOS where the second parameter should be <filename>%date:~6,4%%date:~3,2%%date:~0,2%.txt hope this helps. 1) I have declared a variable in the Parameter like Parameter DefaultValue FileName MSDFF 2) I choosed 'ExecDOS' from after subroutine(Transformer stage). 3) I gave th...

chulett wrote:I have no knowledge of this stage, but if you can't find an explicit 'clear/truncate' option for it, you could always use your original job concept to do that using an empty source and then running your new job.

I have created one more job to clear the table and then i ran this job.

After selecting ExecDOS you need to pass the command to execute in the text box in-front of it. so that the routine ExecDOS can execute it. which command will give the current date? My requirement is i have to add the current date at the end of the file. if i run today then today's date, if i run t...

chulett wrote:From a Windows server it would be ExecDOS. And code in 'Job Control' is not visible to anything inside your job proper. ...

It is throwing 'No command to execute' error message.

Sainath.Srinivasan wrote:Timestamps has colon (:) symbol which is generally interpretted for remote hostname or ip address.

Parameter must not be computed within the job.

Use an afterjob rountine for now. ...

What i have to choose from the afterjob routine combo box ?

Jillion+1. That method too complicated and too Old School. Get Hip Daddy-O. Use a DSMacro as part of the filename in the sequential stage. <filename>#DSJobStartDate#. Use DSJobStartTimestamp if running more then once in a day. Nah, never happen. I gave like #FileName##DSJobStartDate# but the date d...