Search found 5168 matches

by kumar_s
Sat Mar 25, 2006 4:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in logging on the Project
Replies: 5
Views: 1307

Does it allow you to login through dsadm id?
by kumar_s
Sat Mar 25, 2006 4:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Extract COBOL file data using CFF
Replies: 7
Views: 4307

Is the layout includes the redifines? How you imported the COBOL layout? Did you specified 'As Is' option while importing the layout. If it was imported correctly, then you can try to comment the feilds under the redefine and just allow the prime column to be meta data and check. Also try to write i...
by kumar_s
Sat Mar 25, 2006 4:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Is There any way to abort a job after 50 warnings
Replies: 16
Views: 3424

If you need to handle within job, as sugested use teh property available in transforer 'Abort After'. If you need to monitor out of the job, use GetLinkInfo to that particular link for thershold value.
by kumar_s
Sat Mar 25, 2006 3:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple source files single ETL
Replies: 33
Views: 8463

Perhaps ray is saying about head -1 and tail -1.
by kumar_s
Sat Mar 25, 2006 2:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is there any bug in Join stage
Replies: 8
Views: 1741

Most probably girija would be right. Duplicates would cause more number of row in the output than expected.
by kumar_s
Fri Mar 24, 2006 7:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TimeStamp with milliseconds in PX job
Replies: 5
Views: 1270

There isnt any inbuilt funciton available for extracting TimeZone. You need to do workaroud to capture that. Else you can use D code, Iconv,Oconv from UserVariableActivity and pass on the value as a parameter. (If required as a single value as a whole for that job)
by kumar_s
Fri Mar 24, 2006 6:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Passing parameter out of datastage job
Replies: 21
Views: 34623

Search the forum or the online help for USERSTATUS. This can be set with a single value inside a Server job and then easily picked up in a Sequencer and passed in as a parameter to a downstream job. Hi Craig, I have never tried with UserStatus. May I know how to use it? What kind of expression we c...
by kumar_s
Fri Mar 24, 2006 6:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: kill job using job id
Replies: 15
Views: 6609

What you mean by 'kill'. Do you want to delete or want to stop the process or need to release the lock? If you are speaking about releasing the lock based on the job id, select the job name from the job id by executing SELECT NAME FROM DS_JOBS WHERE jobid = 'nnn' from TCL and after retreving the job...
by kumar_s
Fri Mar 24, 2006 6:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Warning If I use JobInvocations....
Replies: 15
Views: 4145

Since the routines are executed within the project, I am not sure if it can be attched to another project.
by kumar_s
Fri Mar 24, 2006 6:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compile error
Replies: 8
Views: 1524

I was under the impression that, if all the clients as disconected and if no running jobs, UNLOCK ALL can be executed :o
Infact while following some set of instruction given by IBM support people, I was asked to do the same.
by kumar_s
Fri Mar 24, 2006 6:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compile error
Replies: 8
Views: 1524

Yes, use LIST.READU EVERY from TCL to get all list of locks.
If you find the job you mentioned in the list, perhap you can release it.
If you dont run any job at the moment, any any client being opened at the moment, you can simply use UNLOCK ALL to release all the locks.
by kumar_s
Fri Mar 24, 2006 5:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning in Column Export
Replies: 9
Views: 2135

What if, if you give the outpu length as blank. Which is capable to handle any value.
by kumar_s
Fri Mar 24, 2006 4:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Is There any way to abort a job after 50 warnings
Replies: 16
Views: 3424

How you call the job, is it through the sequnce or from command prompt. If the job is been called from command prompt by dsjob command, you can make use of 'dsjob -run -warn # {job name}' property. You can provide the warning limit at the -warn parameter.
by kumar_s
Fri Mar 24, 2006 3:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage MVS
Replies: 3
Views: 818

There is no specific forum for MVS.
You can post your needs, and you can find lot of expert available.
by kumar_s
Fri Mar 24, 2006 3:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Header and Trailer
Replies: 8
Views: 5998

I need to check the way to use it in after job subroutine. But you can use the UserVariableActivity to pass these variable to a ExecuteCommandActivity. Which inturns will append the the file with these information. By giving 'echo' in the command and Parameters (DSJobStartDate and DSJobStarTime) pas...