Search found 53125 matches

by ray.wurlod
Tue Dec 19, 2006 4:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sybase Enterprise stage not available?
Replies: 1
Views: 646

Whether or not it's an oversight on the part of the vendor, there is no Sybase Enterprise stage available for version 7.5x2 on the Windows platform. Contact your support provider to learn whether there is any workaround other than using ODBC protocol.
by ray.wurlod
Tue Dec 19, 2006 3:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cleaning the Scratch space
Replies: 9
Views: 9354

Why are they there? Which jobs created them? Are they still required?

The only safe way to delete Data Sets and File Sets is to use either the orchadmin utility or the graphical Data Set Management utility in the Manager client.

DO NOT attempt to delete them using rm commands.
by ray.wurlod
Tue Dec 19, 2006 3:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Could not check all operators
Replies: 8
Views: 4210

Not possible with the small amount of information you've provided. Describe your job design more fully. Inspect (post?) the generated OSH. Try dumping the score, to see exactly what will be run.
by ray.wurlod
Tue Dec 19, 2006 3:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Probelm triggering job via Sequence
Replies: 15
Views: 3608

Can you please post (a) the "job run requested" message from the job sequence's log, and (b) the "job starting" message from job A's job log? Full and complete detail please. Is it possible that Job A is already running from one sequence when you try to trigger it from another? If so, have you consi...
by ray.wurlod
Tue Dec 19, 2006 3:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom error
Replies: 4
Views: 1087

Is that the entire error/warning message? There's nothing in what you've posted that helps, unless one of the columns that has NULL as its value is defined as not nullable.

What was the result of resetting the job?
by ray.wurlod
Tue Dec 19, 2006 3:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: regarding transformer stage
Replies: 3
Views: 876

Use the expression editor to construct your expression. You will learn, by doing so, that job parameter references in expressions do not take the surrounding "#" characters. You should also take the time to name your stages and links meaningfully; it helps diagnosis and maintainability.
by ray.wurlod
Tue Dec 19, 2006 12:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom error
Replies: 4
Views: 1087

Reset the job in Director. This may yield an event "from previous run..." that contains useful diagnostic information. Otherwise, are there any other warnings in the job log?
by ray.wurlod
Mon Dec 18, 2006 10:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: importing ODBC
Replies: 7
Views: 978

Search for Data Element will reveal more. A Data Element is like a luggage tag for data; you can record, for example, that this ten digit number is a tax ID, whereas this ten digit number is a telephone number and yet another is a part number. In short, business metadata. Let's say you have a data ...
by ray.wurlod
Mon Dec 18, 2006 9:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: importing ODBC
Replies: 7
Views: 978

When you click the GetSQLInfo button, or when you click the Create DDL button, the ODBC stage interrogates the data source for its syntax rules. This means that the table definition created is syntactically legitimate (most of the time - some drivers report inaccurately). Whenever you generate metad...
by ray.wurlod
Mon Dec 18, 2006 9:15 pm
Forum: General
Topic: Getting Job Names from Sequences
Replies: 11
Views: 4585

Hi Kim, Ray has suggested to use commandline script to get job names. But this won't help in our case because we are maintaning a single database for job statistics across all the projects. I suggested no such thing. I mentioned that the summary of the sequence run is in the job log. You can get it...
by ray.wurlod
Mon Dec 18, 2006 9:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem with loading sequential file of DB2 table
Replies: 10
Views: 6161

You have quote characters in the COMMENTS and HOME_PHONE fields that match the quote character specified in the Format properties. Change the format as kumar_s suggests.
by ray.wurlod
Mon Dec 18, 2006 9:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential file load problem
Replies: 5
Views: 2425

Is this a server job or a parallel job?

Please mark the post as resolved.
by ray.wurlod
Mon Dec 18, 2006 9:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Large file to split
Replies: 15
Views: 3913

Re: Large file to split

Thanks for u r response, Dsguru I am sorry, i loaded the metadata and the job design is as follow seq.file -----> Transformer ------> multiple sequential files. in the transformer i used the constratin @INROWNUM<10000 ----- FIRSTFILE @INROWNUM>10001AND@INROWNUM like this i am using a condition for ...
by ray.wurlod
Mon Dec 18, 2006 9:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: regarding function used in transformer stage
Replies: 6
Views: 1377

Please mark the post as resolved. Note that Sam's solution is slightly incorrect - the reference to the input column must not be quoted.