Search found 8 matches

by svipul16
Thu Oct 20, 2016 10:53 am
Forum: General
Topic: Status of DSGetJobInfo
Replies: 4
Views: 2512

Status of DSGetJobInfo

We have a server job which just have jcl written in it. This job calls bunch of other parallel jobs and checks the status of the jobs. It checks if the jobs status is runok or runwarn, if not job will abort. Issue we are having is the server job which calls other jobs aborts and says that the status...
by svipul16
Tue Jul 01, 2014 8:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job hangs when the data has spaces
Replies: 3
Views: 1871

Data type of the field is char(20).They are genuine spaces.
by svipul16
Mon Jun 30, 2014 3:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job hangs when the data has spaces
Replies: 3
Views: 1871

Job hangs when the data has spaces

Hi ,

Parallel job is hanging if the input data has spaces in it.If i remove the spaces the the job runs fine.I think it is hanging at the funnel stage.

Does anyone had this issue before?
by svipul16
Tue Oct 14, 2008 1:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to covert string to timestamp in millisecond
Replies: 1
Views: 2309

How to covert string to timestamp in millisecond

Input data is string .I want to convert it to timestamp(26,6) with format YYYY-MM-DD-hh:mm:ss.nnnnnn.How would i get that?

I tried using convert to timestamp function,but its not working.Is there any function or routine for that?
by svipul16
Thu Mar 06, 2008 10:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: date conversion issue
Replies: 7
Views: 2664

Re: date conversion issue

In Transformer do derivation as Left(cloumn_name,4):18:right(cloumn_name,2) I had an issue with date conversion My source file has date formet 'mmddyy' and i need to send to target in other formet lilke mmdd18yy means everytime i have to add 18 to source data and send the data Is there any function ...
by svipul16
Fri Dec 07, 2007 12:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: log information
Replies: 5
Views: 3217

Re: log information

No, if i run sequencer i want the jobnames and there ids which are running in sequence.
thanks for ur reply

[quote="anandkumarm"]HI
Try using dsjob -logsum <project_name> <jobname>
if that is what you are asking for
Thanks
by svipul16
Fri Dec 07, 2007 12:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: log information
Replies: 5
Views: 3217

Re: log information

No, if i run sequencer i want the jobnames and there ids which are running in sequence.
thanks for ur reply

[quote="anandkumarm"]HI
Try using dsjob -logsum <project_name> <jobname>
if that is what you are asking for
Thanks
by svipul16
Fri Dec 07, 2007 10:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: log information
Replies: 5
Views: 3217

log information

Hi,

Is there any method for getting job names and there ids which are in the sequencer.i.e when i run sequencer i want to collect the log information of sequencer which has sequencer id,job ids,jobname,seq starttime,end time.

Thank u

vipul