Search found 7 matches

by chowdary_kish
Mon Feb 24, 2014 9:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel jobs hanging when running through command prompt
Replies: 1
Views: 1208

Parallel jobs hanging when running through command prompt

Hi,

i have few parallel jobs and sequencers.

parallel jobs are running fine without any issues when we running the sequencer through director but the same parallel jobs are hanging when we run the command prompt and autosys.

Please help me in why this is happening

Thanks
by chowdary_kish
Mon Oct 31, 2011 8:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: External Target Stage - Command execution error
Replies: 8
Views: 4774

Re: External Target Stage - Command execution error

This is working fine If I'm using only Date part...Time part is not working :( In this case, try to remove the Date part, just for the testing, and quote the time. I.e., cat >#path#/bio_"`echo "#DSJobStartTime#" | sed -e 's/://g'`".txt Give it a try and tell us what you get. HTH...
by chowdary_kish
Sat Oct 29, 2011 1:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: External Target Stage - Command execution error
Replies: 8
Views: 4774

Sorry... "use it" how / where / for what exactly? Use the output of the Before Subroutine - ExecSh in the job to pass it as filename You will need to establish the file name before the job runs. You do not have access to the output of the before-job subroutine in the way you wish. If you ...
by chowdary_kish
Fri Oct 28, 2011 5:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: External Target Stage - Command execution error
Replies: 8
Views: 4774

is there a way I can use the Output of Before Job routine - ExecSh because im getting it right in there Sample_Timestamp..BeforeJob (ExecSH): Executed command: echo 2011-10-28 19:16:24 | sed -e 's/-//g' -e 's/ /_/g' -e 's/://g' *** Output from command was: *** 20111028_191624 I'm thinking of writing...
by chowdary_kish
Fri Oct 28, 2011 3:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: External Target Stage - Command execution error
Replies: 8
Views: 4774

Im getting same error even without Under score
External_Target_22: Invalid destination program name specified: Invalid hostname: cat >/dv/resrc_disk1/DS_FDP/target/bio_`echo 2011-10-28 | sed -e 's/-//g'``echo 17. [new-impexp/file_export.C:2214]
by chowdary_kish
Fri Oct 28, 2011 12:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: External Target Stage - Command execution error
Replies: 8
Views: 4774

External Target Stage - Command execution error

Hello DS Gurus My requirement is to create a file with Current Time stamp in the file name and populate same Timestamp in the Header record of the File ex: File_20111028_142030.txt header record - HHHHH 20111028142030 ----------- here i'm trying to use DSJobStartTimestamp macro in External Target St...
by chowdary_kish
Wed Oct 20, 2010 2:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Special Characters Conversion Problem
Replies: 2
Views: 2818

Is Unicode enabled on the target table? Is Unicode setup on all intermediate links in the job(s) between the good source file and the database load? Can you confirm (maybe with a copy stage to a sequential file or dataset) if the data being pushed to the database has retained the special characters...