Search found 42189 matches

by chulett
Sat Oct 17, 2009 6:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: string to decimal conversion
Replies: 21
Views: 8368

Again, a string doesn't have a scale. What happens if you remove the scale value?
by chulett
Fri Oct 16, 2009 11:03 pm
Forum: IBM QualityStage
Topic: Exit 17 when trying to start qsrtmngr
Replies: 2
Views: 1621

Does anyone know where these QS exit / error codes might be documented?
by chulett
Fri Oct 16, 2009 5:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Migrating jobs from 7.5 to 8.1
Replies: 2
Views: 877

There's no migration, per se, simply build your 8.1 installation and then import the 7.5 version jobs into it. Of course, make sure all needed stages are installed first.
by chulett
Fri Oct 16, 2009 2:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sending an email to multiple people with multiple attachment
Replies: 5
Views: 2914

That's good news, thanks for verifying that. Could you please mark this post as Resolved now using the button at the top of the page? Thanks!
by chulett
Fri Oct 16, 2009 2:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sending an email to multiple people with multiple attachment
Replies: 5
Views: 2914

One "To" and just use whatever delimiter your email client needs, usually a space: From:abc1@abc.com\nTo:abc2@abc.com abc3@abc.com\nSubject:abc file\nAttach:/abc/test1.csv\nBody:Files are ready If the space doesn't work, try using a comma with no space or a 'comma space' between them. One ...
by chulett
Fri Oct 16, 2009 1:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sending an email to multiple people with multiple attachment
Replies: 5
Views: 2914

Multiple people is simple, either use a contact group (best answer) or literally just provide multiple email addresses for the 'To' piece. I don't believe that multiple attachments are supported, however. What I've done in the past is create a zip archive for multiple files and then attach the zip f...
by chulett
Fri Oct 16, 2009 1:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Developing a Batch File to Back up a complete proyect
Replies: 32
Views: 10942

... and I still have no idea what the '20 mainframe objects' might have been. :?
by chulett
Fri Oct 16, 2009 1:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Developing a Batch File to Back up a complete proyect
Replies: 32
Views: 10942

:!: Well... rather than delete my previous post, let me simply print a retraction. I was wrong, the connectors are there in the list of things I can import, I just didn't see them the first time I looked because they were lost in my large list between the Stage Types and the Routines. They are there...
by chulett
Fri Oct 16, 2009 1:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple jobs compile error
Replies: 3
Views: 2083

And how were you able to solve it?
by chulett
Fri Oct 16, 2009 1:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Exception raised in GCI subroutine
Replies: 4
Views: 1924

I'm afraid I don't know exactly what that 'access violation' would mean. Any other issues when it happens, disk space perhaps? Are you running anti-virus software on that server? Any chance another process is trying to 'use' the file at the same time, perhaps even trying to write to it as well?
by chulett
Fri Oct 16, 2009 10:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Exception raised in GCI subroutine
Replies: 4
Views: 1924

That line number is from the SEQOpen routine, not the transformer. Are you reading from or writing to this file? Is it repeatable or a 'random' error?
by chulett
Fri Oct 16, 2009 10:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RTI & WISD
Replies: 6
Views: 1837

Check Ernie's post here.
by chulett
Fri Oct 16, 2009 10:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Developing a Batch File to Back up a complete proyect
Replies: 32
Views: 10942

[please disregard this post] OK, you're correct in that they are not something that will import back from the GUI. When I selected my .dsx file from the Designer Import option and told it it do a 'selective' import, it brought in almost everything in the file but threw this message up as well: 20 m...
by chulett
Fri Oct 16, 2009 9:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Conditional stop within a Datastage Job
Replies: 5
Views: 3486

You can't "output an empty file" if the check is triggered during the processing, all you can do is shut down any further processing but whatever was already output to the file will still be there. If you really need an 'all or nothing' output, you'll need a 'pre' step to check the data fi...
by chulett
Fri Oct 16, 2009 7:27 am
Forum: General
Topic: Connecting to Command Line Interface
Replies: 5
Views: 2364

I meant for you to post exactly what you set, the variable name and value you set it to.