Search found 53125 matches

by ray.wurlod
Thu Feb 23, 2006 2:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: NLS
Replies: 4
Views: 2518

Are you specifying that the FTP should convert from EBCDIC to ASCII ?
by ray.wurlod
Thu Feb 23, 2006 2:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: integration testing
Replies: 2
Views: 810

Are you asking whether there is any mechanism for preventing jobs from being run independently, only allowing them to run under control? The answer to that is yes. Add a few lines of job control code that detect the name of the job's controller; if there is none, then issue a stop request.
by ray.wurlod
Thu Feb 23, 2006 2:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: error connecting to UniData 6
Replies: 9
Views: 4695

This week Windows, next week UNIX. I'm a self-employed contractor - I don't have my own copy of DataStage (my fees would need to be way higher to afford it). Haven't connected to UniData in some time. However, I do teach IBM classes in both UniVerse and UniData, so I have some idea of what I am sayi...
by ray.wurlod
Thu Feb 23, 2006 2:01 pm
Forum: General
Topic: DS_JOBS
Replies: 18
Views: 14353

Try it with dssh rather than uv.

Code: Select all

/ds/Ascential/DataStage/DSEngine > . ./dsenv 
/ds/Ascential/DataStage/DSEngine > cd ../Projects/YourProject
/ds/Ascential/DataStage/Projects/YourProject > $DSHOME/bin/dssh "select * from DS_JOBSwhere NAME='PSEXPSLSE';"
by ray.wurlod
Thu Feb 23, 2006 1:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to avoid NULL to reject - in SWITCH case
Replies: 20
Views: 6515

Have you reported this apparent bug through your support provider?

Is any of you who are experiencing this symptom running parallel jobs on a Windows platform? I note that the OP is on UNIX. If on UNIX, can you please post what kind of UNIX (for example AIX, HP-UX, Solaris, etc.)?
by ray.wurlod
Thu Feb 23, 2006 2:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to get Job log before compilation ?
Replies: 13
Views: 3179

Read this post and adapt the advice given there.
by ray.wurlod
Thu Feb 23, 2006 2:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem in upating SQL Server Table through ODB Stage
Replies: 8
Views: 1803

I'd certainly suspect the difference in drivers. I'd also be concerned that the versions of DataStage is lower in test (and that 7.0.0 has been through 65 patch releases!!!). I'd recommend upgrading test to the same version as development, so that you're comparing apples with apples.
by ray.wurlod
Thu Feb 23, 2006 2:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: to find job names and start date from my project
Replies: 2
Views: 724

Welcome aboard. :D Open Director. Make sure you have status view open. If you prefer, right mouse click and filter on Finished jobs only. Uncheck "Categories" from the View menu. This gives all jobs in one screen. Select Print from the Project menu. In the common print dialog check "Print to File". ...
by ray.wurlod
Thu Feb 23, 2006 2:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Splitting CSV fields with Quotes
Replies: 5
Views: 1942

It's almost an impossible problem to solve without writing a routine. You read the entire row as a single string and process it through the routine that has a "WithinQuotes" flag that tells it whether to ignore the comma inside the quotes, and maybe change the real delimiters to something else, such...
by ray.wurlod
Wed Feb 22, 2006 11:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Extended Memory Support
Replies: 0
Views: 485

Extended Memory Support

Does anyone have any experience running DataStage (7.5.1A ideally) on Windows with Extended Memory Support enabled? If so, does it make any difference? Can DataStage make good use of the expanded memory? (No "in theory" answers, please - I can work them out for myself.)
by ray.wurlod
Wed Feb 22, 2006 11:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Splitting CSV fields with Quotes
Replies: 5
Views: 1942

Yes. Get "them" to deliver you a legal CSV file! Nothing could be easier.

If it's an export from Excel, go for tab-delimited.
by ray.wurlod
Wed Feb 22, 2006 11:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Mapping multiple rows to a single row
Replies: 6
Views: 2435

Not dirty, just large. You wouldn't gripe at using 76 local variables in a program would you? Then what's wrong with 76 stage variables in a Transformer stage (which become 76 local variables in the generated code)?
by ray.wurlod
Wed Feb 22, 2006 11:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DsLofInfo function In datastage pz
Replies: 3
Views: 1055

It's the string that appears in parentheses in the first line of the logged message.
by ray.wurlod
Wed Feb 22, 2006 11:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dataset column limit
Replies: 2
Views: 1202

Sounds like something in column 41 through 49. Perhaps trying to shoehorn N+1 characters into a Char(N) field?