Search found 53125 matches

by ray.wurlod
Tue Aug 15, 2006 11:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can I get an evaluation version of Px
Replies: 3
Views: 1018

Depends on whether you can convince IBM India that providing you with such is likely to turn into a sale. In general IBM policy is not to hand out evaluation versions unless there is a strong, and qualified, chance of a sale. This is not cheap software! There is definitely no such thing as a "person...
by ray.wurlod
Tue Aug 15, 2006 11:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL Server Binary TimeStamp
Replies: 6
Views: 3019

What specification did you use with Oconv()? Try Iconv() with "MX0C" as the conversion, see what you get with that. It's probably an ordinal date/time, so you will then need to convert the total seconds into days (then convert with Oconv() to a date) and seconds (then convert with Oconv() to a time)...
by ray.wurlod
Tue Aug 15, 2006 11:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Archived DS Logs that are in a readable form
Replies: 15
Views: 4633

I must agree with Kim there. As with any database product, you can do damage if you don't know what you are doing, and even more if you do know what you are doing! But there are UniVerse sites out there that have run literally for years in a 24x7 operation, because they are well looked after. One I ...
by ray.wurlod
Tue Aug 15, 2006 11:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: CLI for oracle, informix and SQL server
Replies: 8
Views: 1779

IBM has a triffic product just for you called the Information Integrator. Contact any IBM Software Group sales dude, who will be more than happy to hear from you. This is one of the tools that will sit on the same platform as the Hawk release of DataStage etc., and integrate smoothly with it to prov...
by ray.wurlod
Tue Aug 15, 2006 11:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server Routine
Replies: 6
Views: 1111

Tech Tip # 402
Become aware of what's available - doing so can prevent unnecessary re-invention of many different wheels!
by ray.wurlod
Tue Aug 15, 2006 11:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DB2 UDB Bulk Load problem
Replies: 2
Views: 1818

Looks like a problem writing the data file for the bulk loader. Did your disk become full? Did the I/O system get clogged up so that a timeout may have fired?
by ray.wurlod
Tue Aug 15, 2006 11:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: error compiling job
Replies: 4
Views: 930

Click on the More button to get the actual compiler output. This will describe exactly where the error occurred, what the compiler found there, what it expected to find there, and a brief description of the problem. Take time to absorb all the information returned and you will find your diagnostic t...
by ray.wurlod
Tue Aug 15, 2006 11:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ftp or copy
Replies: 14
Views: 3810

Philosophical Observation
One cannot with confidence answer any question containing the word "all".
by ray.wurlod
Tue Aug 15, 2006 11:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Aggregate - Out of Sequence - Underscore before A-Z
Replies: 7
Views: 2326

Bug? I assume you've reported this to your support provider. Both stages should use the same character set (for example ASCII) and the same collation sequence. Are you using NLS and, if so, how have you set the COLLATE category in your locale? It may be - for example - that the Aggregator stage does...
by ray.wurlod
Tue Aug 15, 2006 11:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File Lookup
Replies: 10
Views: 2948

The link information says that the rows were written to the hash file. No, the link information says that the rows were SENT to the hashed file. Something has apparently prevented their being written. Can you try two diagnostic things? First, replace the Hashed File stage with a Sequential File sta...
by ray.wurlod
Tue Aug 15, 2006 11:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: OCONV Failed Error
Replies: 9
Views: 4021

The ODBC stage uses BCI functions. Somewhere in your metadata is at least one column requiring conversion. That's where the Oconv() is being called. It might, for example, be an "MX" or "MX0C" conversion for dealing with the hexadecimal characters, and have found a character > "F". (Note - I am not ...
by ray.wurlod
Tue Aug 15, 2006 10:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complex flat file
Replies: 2
Views: 860

Can you post the COBOL FD from which you imported the table definition used in the CFF, so that we can see whether there's anything "tricky" in it?
by ray.wurlod
Tue Aug 15, 2006 10:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Shutdown Procedures -- MASTER OFF ALL
Replies: 3
Views: 959

The right amount of time is "till they're all gone". You can monitor with netstat or ipcs (UNIX commands but, since you have 7.5x2, you have a UNIX shell in MKS Toolkit). A Windows/DOS equivalent of ipcs (only for DataStage) is shrdump. Windows/DOS has netstat available.
by ray.wurlod
Tue Aug 15, 2006 10:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trim on char datatype
Replies: 11
Views: 4120

You CAN use Trim on Char data types but, because the target field is Char, it is then automatically padded again with $APT_STRING_PADCHAR characters!
by ray.wurlod
Tue Aug 15, 2006 10:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Java Pack
Replies: 1
Views: 923

Did you install the client GUI as well as the plug-instage on the server? Have you read the PDF file that comes with the Java PACK?