Search found 53125 matches

by ray.wurlod
Fri Nov 04, 2005 3:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem adding jobs to schedule
Replies: 15
Views: 14366

Assuming that the Scheduler service is running (the error message suggests you've got as far as trying to execute an AT command), the text of the message indicates a problem in DataStage. That there's "garbage after the time specification" in the AT command is something you need to take up with your...
by ray.wurlod
Fri Nov 04, 2005 3:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Editing Key Expressions
Replies: 5
Views: 1263

Presume you're using a Lookup stage here. Are you on 7.5 or an earlier version?
by ray.wurlod
Fri Nov 04, 2005 6:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Connect to Database using Job control
Replies: 8
Views: 2440

You could have had a more robust script, that only generated an exit status of 0 if absolutely everything was OK. You can use DataStage BASIC functions to access a database, but you will need to purchase an ODBC driver licence. Don't be fooled by the fact that it works with the DataStage-supplied dr...
by ray.wurlod
Fri Nov 04, 2005 6:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to capture Errordescription into ErrorTable
Replies: 3
Views: 828

From the same list that you get DBMSCODE (the list of output link variables) choose LASTERR. This contains the error text.
by ray.wurlod
Fri Nov 04, 2005 6:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequence thinks job is not runnable
Replies: 9
Views: 2938

Would you care to share the solution that you have, Yamini?
by ray.wurlod
Fri Nov 04, 2005 5:57 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: how to join the two db2 sources
Replies: 4
Views: 3036

You could also create a TX map that references the join within DB2. Provided, of course, that you have DataStage TX and the TX plug-in stage installed.
by ray.wurlod
Fri Nov 04, 2005 1:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Migrtion to 7.5 from 6.0.3
Replies: 2
Views: 756

At worst, import them again, and watch the progress carefully.
by ray.wurlod
Fri Nov 04, 2005 1:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSR_LICENSE GET PROTECT
Replies: 4
Views: 1821

Yes. :lol:

But it would be more helpful if you were to post the entire line out of the ps report, so the explanation would be clearer.
by ray.wurlod
Fri Nov 04, 2005 1:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Protect jobs from delete
Replies: 11
Views: 3024

Sure. It's basically a 'switch' managed from the Administrator client. I was able to lock jobs from delete by changing the permissions on the internal files of the jobs. I tried this on some test jobs. Seems to work. As long as I use chmod -R 544 on the *220(220 my job num,which will include RT_LOG...
by ray.wurlod
Fri Nov 04, 2005 1:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Environment variable access in Parallel Transformer
Replies: 5
Views: 1957

Why do you think that's a bug? :?

You don't specify the "$" in C's getenv() function. Why should the C-based parallel Transformer stage be different?
by ray.wurlod
Fri Nov 04, 2005 1:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: converting character to number
Replies: 2
Views: 1145

It's the primary task of the Modify stage to convert data types. You need one of the ..._from_string functions, where ... represents the appropriate numeric data type, for example dfloat_from_string().
by ray.wurlod
Fri Nov 04, 2005 1:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DATASTAGE Migration Project and Devt. Project
Replies: 1
Views: 858

Post ideas, requests, and comments regarding content and structure of the FAQs forum here. I don't think this is really the correct forum. Since you're new, I won't be as harsh as normal (no pun intended). The Development project is where you do your development. Then you move it into a test/QA env...
by ray.wurlod
Thu Nov 03, 2005 2:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: surrogate ID generation in DS EE
Replies: 18
Views: 6832

Will this scale to N nodes for N > 2 ?
by ray.wurlod
Thu Nov 03, 2005 2:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: About Modify stage function
Replies: 3
Views: 1360

There are quite a few errors in the Modify stage chapter of the Parallel Job Developer's Guide, which seems to have been written by someone who used to design server jobs. Always check with the Orchestrate Operators manual.
by ray.wurlod
Thu Nov 03, 2005 2:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error in mutex_lock() - Invalid argument
Replies: 1
Views: 666

Report it to your support provider. ds_ipcgetnext() is an internal function.

Disable row buffering and don't use IPC or Link Partitioner/Collector stages to make the error go away.