DSXchange

In the Install Guide for PX, there should be a section about supported versions of databases AND the OS they are supported on. If you're having trouble with writing partitioned data to DB2, try putting a collector stage before the DB2 Stage. Collect your streams of data into one stream and write tha...

That is weird. Are you planning on filing a bug report with Ascential? We'd like to know the outcome if you do.

Thanks,
BP

Seems like it should work, so I don't know why it's not. Can you look at the compiled transform code and determine what type @INROWNUM is and if it is ever initialized and/or incremented? If you don't know C, just post the code and we'll help you look for it. If you can't get inrownum to work, try u...

Scratch Space Full means that the physical disk that the Scratchdisk is pointing to in your config file is filling up. You need to point your scratchdisk to a physical disk with more space.

- BP

Is this for a sequential file export?
-BP

Ray,

You're right. Word-aligned, I believe. I don't know much more than what I already posted. I don't know about the NLS stuff.

- BP

Is there a 'null value' at the field level? If so, try setting that to ' ' (a space) and then try running your job again.

- BP

Set it in Job Properties. You can add a environmental property on the same page where you can add parameters.

-BP

Vasu,

Please try posting this question to the regular DataStage forum. I feel this might not be a problem specific to PX.

Thanks,
BP

Sorting is required for remdup as it looks at adjacent rows to find key matches.

- BP

Do you wish to specify a file format for importing or for exporting (i.e. writing)? Check out "Field Properties" for the import/export stage. I think you want to use the property 'padchar'.

-BP

The subtraction operator is overriden for the APT_DATE type. You can subtract two APT_DATEs, and the result will be given to you in number of days. You can use other date functions to convert this into MON/DAY/YEARS.

- BP

As with almost all parallel stages that work on key fields, you must first hash the data and then sort the data by the key fields before you pass it to aggregator and remove dups. Are HASHing AND SORTing by the right keys b/c you use aggregator or rem_dup?

Thanks,
BP

You can also read/write from/to a file set using PX. A file set is a set of partitioned sequential files, similar to a dataset, yet viewable w/o PX. A PX trick with using datasets is to keep your data byte-aligned. I got this tip a while ago, and from what I understand, byte-alligned data is easier ...

I am trying to use the ORACLE Bulk Loader stage to generate a ctl for a record layout that contains a timestamp field with the following format: TIMESTAMP "YYYY-MM-DD HH24:MI:SS.FF6". I don't really see a good way to do this b/c the time-spec in the stage is a drop down that doesn't have a...