Search found 230 matches

by naren6876
Mon Mar 14, 2005 3:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: After Job Routine
Replies: 5
Views: 1307

As you said, i have tried that but sequencer job will get abort right before calling After Job routine. In the routine activity can i pass anything as a argument?. The following error iam getting. SEQ1..JobControl (fatal error from DSAttachJob): Job control fatal error (-12) (DSOpenJob) Invalid job ...
by naren6876
Mon Mar 14, 2005 1:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: After Job Routine
Replies: 5
Views: 1307

After Job Routine

Hi,

How can i call a After Job Routine from Sequence job?.

Any solution ?

Thanks in advance

Naren
by naren6876
Mon Mar 14, 2005 12:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading folder name
Replies: 3
Views: 616

by naren6876
Mon Mar 14, 2005 12:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading folder name
Replies: 3
Views: 616

Reading folder name

Hi,

I have a folder as input.and one Lookup hash File with the columns like Folder Name.If it matches then i need to pass the folder contents to some other folder o sequential file.

Any suggessions pls

Naren
by naren6876
Mon Mar 14, 2005 11:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SEQUNCE
Replies: 2
Views: 620

uote="roy"]Hi,
well a routine activity can take a dummy argument for starters.
just throw in a parameter and don't use it.

IHTH,[/quote]

Is there any other way to call after job routine?

Naren
by naren6876
Mon Mar 14, 2005 10:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SEQUNCE
Replies: 2
Views: 620

SEQUNCE

HI,
HOW TO CALL A AFTER-JOB ROUTINE FROM SEQUNCE?
IF I USE A ROUTINE ACTIVITY WHAT SHOULS I PASS THE INPUT ARGUMENT?.
BECAUSE, WHEN I USE THIS ROUTINE FOR OTHER SERVER JOB I DIDN'T PASS ANY ARGUMENT AND THAT WORKS FINE.


ANY SUGGESSIONS WILL BE HIGHLY APPRECIATED,

THANKS,
NAREN
by naren6876
Mon Mar 14, 2005 9:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Writing the data to sequential file
Replies: 3
Views: 684

Thanks alot KEN I also don't know what this section: Answer=OConv(Answer,"MCP") Loop I= Index(Answer,"'",1) If I>0 Then Answer=Answer[1,I-1]:Answer[I+1,Len(Answer)] Until I=0 Repeat is doing for you. You should probably not use it. It appears to be removing single quotes, which c...
by naren6876
Sun Mar 13, 2005 12:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Writing the data to sequential file
Replies: 3
Views: 684

Writing the data to sequential file

Hi, By using the below routine i can write the logfile to sequential file. But the thing is i want to write each Eventid in NewLine.Any suggessions pls StartDate = DSGetJobInfo (DSJ.ME, DSJ.JOBSTARTTIMESTAMP) SummaryArray = DSGetLogSummary(DSJ.ME,DSJ.LOGANY,StartDate,"9999-12-31", 0) Answe...
by naren6876
Fri Mar 11, 2005 11:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to create a sequential file?
Replies: 11
Views: 4821

How to write each element in the Array in the next(new) line. Actually, Arnd is wrong, you use the CREATE command if the file does not exist. If you have all of your data in a dynamic array, you can use this logic to write the dynamic array to a file: txt = "your data you want to write out"...
by naren6876
Fri Mar 11, 2005 9:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating sequential file in unix server
Replies: 3
Views: 1098

Thanks for all your input Ensure that you can execute the UNIX command manually, logged in as the same user ID that you use to run DataStage jobs and attached to the project directory. This will allow you to determine whether there are any operating system obstacles to your using the command. Reset ...
by naren6876
Thu Mar 10, 2005 12:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating sequential file in unix server
Replies: 3
Views: 1098

Creating sequential file in unix server

Hi

How to create a xyz.txt file in particular Folder in unix server(Before job subroutine)?.

Iam using ExecSH and the input value is "touch xyz.txt". If i run the job it will abort?.

Any clues please,

Thanks in advance,

Naren
by naren6876
Wed Mar 09, 2005 3:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading RT_LOG files
Replies: 2
Views: 1440

Reading RT_LOG files

Hi,

How can i read a RT_LOGnn file where nn is the job number


Thanks in advance,
Naren
by naren6876
Wed Mar 09, 2005 2:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: capture warning message
Replies: 15
Views: 7253

HI,

HOW CAN I READ THIS RT_LOGnnn FILE?.
HOW CAN I IDENTIFY THE CORRESONDING JOBS RT_LOGnnn FILE?
THANKS,
NAREN
Sainath.Srinivasan wrote:Read from the hash-file RT_LOGnnn where nnn is the job number.
by naren6876
Tue Mar 08, 2005 3:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: sequential file
Replies: 4
Views: 1796

THANKS RAY. So that is the basis of your "remembering"; the stage variable svPrefix is defined as If InLink.StringCol[10,1] = "X" Then InLink.StringCol[3] Else svPrefix What steps do you take to ensure that the tenth position is always "X" in row number 1? If uncertain,...
by naren6876
Tue Mar 08, 2005 3:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: sequential file
Replies: 4
Views: 1796

Ray, Here the constraint is if Substrings(inputlink,10,1)="X" then only we need to retrieve the next three characters to the "X". and add those three characters to the next records until Substrings(inputlink,10,1)="X" occurs again. Thanks Naren Are there always three ro...