Search found 42189 matches

by chulett
Tue Oct 20, 2009 5:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Migration from DS7.5.2 to IIS 8.1.1 - Possible NLS issues
Replies: 17
Views: 6212

Prasanth, you really should start your own thread for questions like this, not jump on the end of someone else's conversation.
by chulett
Tue Oct 20, 2009 5:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to open project 'XYZ' - 81016. ( Job Migrated )
Replies: 13
Views: 6999

I'm not aware of what circumstances would cause the failure of the BASIC Transformer in a PX job like that. I would think the next step would be to contact your official support provider and see if they can resolve it, then post the results back here. As to a 'workaround', to me that would be to not...
by chulett
Mon Oct 19, 2009 11:45 pm
Forum: General
Topic: generate HTML report in datastage
Replies: 22
Views: 17973

1) That's been my typical 'solution' as well, I tend to keep output directory names short and near the root, typically right under C:\Temp as well. :wink: 2) Ah... know what you mean about the crap inherent in a dev project, that sounds like a practical solution to the problem provided the dev job i...
by chulett
Mon Oct 19, 2009 11:40 pm
Forum: General
Topic: OT: Really useful freeware Windows utility - PathCopy
Replies: 3
Views: 2001

I'm assuming this works under Vista as well, yes?
by chulett
Mon Oct 19, 2009 11:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job substituting default params in place of the passed ones
Replies: 13
Views: 2671

What exact 8.x version are you running?

ps. There was no code posted but I don't think we need it... yet.
by chulett
Mon Oct 19, 2009 11:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Execute Command Activity in Sequence Job -- return value
Replies: 8
Views: 11102

Are you certain you are setting your script's exit status properly? Can you post the log entry from your Execute Command stage - it should show the output and the 'reply', which is the Return Code.
by chulett
Mon Oct 19, 2009 4:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transforming a flat file into XML
Replies: 6
Views: 3673

You'll end up with something like this:

Code: Select all

<client>
 <ClientID>123456</ClientID>
 <CountryCode>CA</CountryCode>
 <Revenue>$1,000,000</Revenue>
</client>
All in one line with proper headers (etc), of course, but is that more like what you actually need?
by chulett
Mon Oct 19, 2009 2:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: running scripts in datastage
Replies: 11
Views: 2157

Execute Command stage.
by chulett
Mon Oct 19, 2009 1:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transforming a flat file into XML
Replies: 6
Views: 3673

Re: Transforming a flat file into XML

Sample output: Client ID Country Code Revenue 123456 CA $1,000,000 I'm a little lost as your sample of the output you are trying to create is not XML at all, it's simply another flat file in a more 'report like' format. The forum software removes all of the "extra" spaces you have in ther...
by chulett
Mon Oct 19, 2009 10:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: migration from 7.5 to 8.1
Replies: 3
Views: 1524

It's pretty obvious when you see it but I don't recall the exact name... OCI82OCI9 or something close? If you have the client cdrom, there should be a 'utilities/supported' (or perhaps the reverse) on it where you can find it along with instructions.
by chulett
Mon Oct 19, 2009 9:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: migration from 7.5 to 8.1
Replies: 3
Views: 1524

Yes, you should have a 'utility' on the 7.5.x media to automatically convert all of those OCI8 stages to OCI9 stages.
by chulett
Mon Oct 19, 2009 9:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can I have an Empty designer and Job control page in a job.
Replies: 2
Views: 1176

No, from what I recall you need something to process on either the Job Control tab or the job's canvas, although that 'something' could be as simple as a call to DSLogInfo.
by chulett
Mon Oct 19, 2009 7:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ERROR: Failed to open project Status code = 80011
Replies: 13
Views: 23209

"-jobstatus" is fine, it is one of the "wait" options. And both the -domain and -server tags are missing, what you thought was server is the domain and the "not sure" thing is the server name. :wink:
by chulett
Mon Oct 19, 2009 7:38 am
Forum: General
Topic: generate HTML report in datastage
Replies: 22
Views: 17973

1) It should work fine with them, as noted. Are you sure it should have "My Documents" twice in the pathname? The other thing is to go back to the "8.3" short file name for the problematic pieces. For example "My Documents" is probably "MyDocu~1". 2. I've neve...
by chulett
Mon Oct 19, 2009 7:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Developing a Batch File to Back up a complete proyect
Replies: 32
Views: 10942

chulett wrote:Can you detail exactly what tool / process you are using for the import?