Search found 42189 matches

by chulett
Wed Jun 17, 2009 7:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Looping in DataStage
Replies: 17
Views: 27400

Try Convert() instead and see if that helps. If not, post the log entry that shows the Execute Command results and the returned value.
by chulett
Wed Jun 17, 2009 7:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: main_program: Fatal Error: Added field has duplicate identif
Replies: 3
Views: 5340

Sorry, but finding an old post and saying you have 'the same thing' is singularly unhelpful. Please start your own post and describe in detail your issue and the job design you are seeing the problem with.
by chulett
Wed Jun 17, 2009 7:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What is "parameter1" in ODBC DB2 wire protocol err
Replies: 19
Views: 9719

Didn't mean that either one of you actually said that. It just seems to me that we're already well past the point where this should have been handed off to support or at least have them involved as well.
by chulett
Wed Jun 17, 2009 7:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Running a stored procedure through datastage
Replies: 4
Views: 2299

Probably ODBC. Or run it from your command line using whatever option you have there, such as sqlplus for Oracle.
by chulett
Wed Jun 17, 2009 7:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL Server 2005 Connection Error
Replies: 4
Views: 1974

Nothing needs editing in the 'branded' directory. Plus you need to edit the uvodbc.config file in each Project directory you want to leverage the connection from.
by chulett
Wed Jun 17, 2009 6:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Iconv and Oconv Date Conversion
Replies: 5
Views: 37436

Then time to mark your topic as Resolved using the button at the top of the page! :wink:
by chulett
Wed Jun 17, 2009 6:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sort stage
Replies: 6
Views: 1837

In other words, be patient. The Server Sort stage is not the speediest animal on the planet.
by chulett
Wed Jun 17, 2009 6:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Looping in DataStage
Replies: 17
Views: 27400

This is indeed probably the case. Either use the <1> syntax noted or use Convert() to remove the @FM characters.
by chulett
Wed Jun 17, 2009 6:48 am
Forum: General
Topic: Calling Stored Procedure using ODBC stage
Replies: 5
Views: 1360

I know a stored function can be used there, not so sure about the stored procedure, though. As long as you can 'select' from the sproc in a standard sql format, then I would suppose it would work. :?
by chulett
Tue Jun 16, 2009 8:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What is "parameter1" in ODBC DB2 wire protocol err
Replies: 19
Views: 9719

In other words, refer this to your official support provider. :wink:
by chulett
Tue Jun 16, 2009 8:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date -1
Replies: 10
Views: 2341

and claim_date=trunc(sysdate)-1
by chulett
Tue Jun 16, 2009 8:30 pm
Forum: General
Topic: Load an IXF File
Replies: 10
Views: 2605

If it's anything like an Oracle export, you'd need to read it with a Sequential File stage as one long varchar and then identify and parse things from there.
by chulett
Tue Jun 16, 2009 4:34 pm
Forum: General
Topic: Schedule Compiling batch script
Replies: 11
Views: 2842

I know, which is why I asked why one would 'need' such a thing. :?
by chulett
Tue Jun 16, 2009 4:23 pm
Forum: General
Topic: Schedule Compiling batch script
Replies: 11
Views: 2842

ray.wurlod wrote:Even easier is this approach. Use the Multiple Job Compile tool and check the "select only uncompiled jobs" check box.
True... except for the apparent need to schedule this so as to run unattended.
by chulett
Tue Jun 16, 2009 4:21 pm
Forum: General
Topic: Schedule Compiling batch script
Replies: 11
Views: 2842

nagarjuna wrote:Use : -jobstatus in tandem with dscc .
Small correction: "-jobinfo" as there is no "-jobstatus" option. :wink: