Search found 210 matches

by allavivek
Fri Sep 10, 2010 7:20 am
Forum: General
Topic: trimming line terminator
Replies: 17
Views: 7540

Sorry chulett , actually i was out of my office yesterday so i couldnt post error message.. seq_xxxxxxxxxxxxx..JobControl (@yyyyyy): Executed: . script.ksh BEGIN param1 param2 param3 30 param4 param5 Reply= param6 param7 seq_xxxxxxxxxxxxx Output from command ====> seq_xxxxxxxxx..JobControl (@yyyyyyy...
by allavivek
Thu Sep 09, 2010 7:31 pm
Forum: General
Topic: trimming line terminator
Replies: 17
Views: 7540

Chulett, Im my file i have like aaa,bbb,ccc while processing loop for values aaa,bbb it was processing good but for ccc the sequence is getting failed... in loop iam having execute command as ... . somescript param1 param2 the error coming was.. command : . somescript param1 reply: param2 execution ...
by allavivek
Thu Sep 09, 2010 6:17 pm
Forum: General
Topic: trimming line terminator
Replies: 17
Views: 7540

Hi ray, basically i was reading delimited values from file to loop to perform list loop. When it comes to last field the sequence is getting executed. ......execute_command1 --->start loop---->user variable----->execute command2 ---->stop------ The execute command 2 was getting failed because of las...
by allavivek
Thu Sep 09, 2010 3:40 pm
Forum: General
Topic: trimming line terminator
Replies: 17
Views: 7540

I even tried

Convert(@FM,',',Trim(Execute_Command.$CommandOutput," "))

not working still


Any suggestions
by allavivek
Thu Sep 09, 2010 3:32 pm
Forum: General
Topic: trimming line terminator
Replies: 17
Views: 7540

trimming line terminator

Hi All, I was trying to trim line terminator that was causing my sequence to get aborted.. In sequence i am using loop through list of items.The last field is taking line terminator and causing termination... I tried convert(@FM,",", Execute_Command.$CommandOutput) before loop activity but...
by allavivek
Thu Sep 09, 2010 2:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: pasing parameter from script!!
Replies: 5
Views: 1557

Add command set -vx before dsjob command in your script. This will give you the trace of the commands. Check what is passed to dsjob. Hi anbu I tried using set -vx It was not passing file params... What i did was i concatenated all params to single varaible and passed as param.. I guess it went wro...
by allavivek
Thu Sep 09, 2010 1:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: pasing parameter from script!!
Replies: 5
Views: 1557

Check whether you are passing the right variable to the job? Whether value was assigned to it? Thanks anbu for reply , Yes i was passing the same variable with value passed as input to script. When iam seeing in director log i cannot see any value assigned to this param... Due to no value passed th...
by allavivek
Thu Sep 09, 2010 1:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: pasing parameter from script!!
Replies: 5
Views: 1557

pasing parameter from script!!

Hi All,

I was trying to pass the filename param from script to sequence.

It was not getting passed , an empty value is getting passed and when i give the value in sequence properties . its working..

the file name changes for each run ...

Do i need to set any thing to make this work...

thank you
by allavivek
Wed Sep 08, 2010 2:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Move command not working..
Replies: 4
Views: 1401

Hi anbu Thank you for replying ..

Actually the error is the Time_Stamp param is having space appended to it causing mv to take .dat #working_dir#/#InputFilename# as target..

I placed uservariable activity before command and removed space...

thank you...
vivek
by allavivek
Wed Sep 08, 2010 2:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Move command not working..
Replies: 4
Views: 1401

Yes it is working..
by allavivek
Wed Sep 08, 2010 2:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Move command not working..
Replies: 4
Views: 1401

Move command not working..

Hi All, I was trying to execute mv command in activity as follows.. #PATH#/#DataFilename#_#Time_Stamp.$CommandOutput#.dat #working_dir#/#InputFilename# sequence was getting aborted and message coming as... seq_xxxxxx.JobControl (@Data_File_Move): Executed: mv /home/xxxx/xxx/xxxxx_100908155936 Reply=...
by allavivek
Wed Sep 08, 2010 1:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trying to Append time stamp to file name!!
Replies: 7
Views: 1983

Can you post the value of filename from director? Did you get the same error message after the erreplace change? yes anbu , But i tried changing the datatype of timestamp param to string in job parameters and it worked... Do we should have a datatype of string for timestamp value?? I was unable to ...
by allavivek
Wed Sep 08, 2010 1:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trying to Append time stamp to file name!!
Replies: 7
Views: 1983

anbu wrote:Can you post the filename in this run?
full file name is

#working_dir#/#param_DataFilename#_#Param_timestamp#.dat


param_timestamp is what iam trying to get from sequence..
by allavivek
Wed Sep 08, 2010 1:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trying to Append time stamp to file name!!
Replies: 7
Views: 1983

anbu wrote:Dont add space to the timestamp. Try this

Code: Select all

Erreplace(timestamp,@FM,"") 
Hi anbu ,

Thaks for reply ..i did tried that option but still error persists..

Thnak you
by allavivek
Wed Sep 08, 2010 1:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trying to Append time stamp to file name!!
Replies: 7
Views: 1983

Trying to Append time stamp to file name!!

Hi All, I was trying to generate file name as #filename#_#timestamp#. I was generating timestamp in sequence using command as date '+%y%m%d:%H:%M:%S' while running sequence job is getting aborted and error is When processing argument -fileWhen processing path: /home/xxxx/xxx/file_100908:14:58:00 .da...