DSXchange

As Ray said, you can use the Unix split command on the output. That is probably your best bet, since you can specify 150,000 records per file and not have to know anything about the input file itself. If you need to it in DX, you can try exporting to a file-set. While you cannot specify the number o...

Basically the Surrogate Key generates a unique number to each record using a counter. By default the counter starts at 0, but you can specify another number if necessary. For example, if you were generating keys to a table that gets appended daily, you may want to get the max id in the table, and us...

If what you say is true that you have 2 rows from left and from right, with the same keys, then the output of the join is correct. Take the following rows, for example (ignore code reference, just used code formatting to keep data formatted)... Row Left Right 1 a a 2 a a In the join (inner or left-o...

I am reposting this message (from http://www.dsxchange.com/viewtopic.php?t=92057 ) to see if I can stir up some more info: We are trying to resolve the following warning message from DS: Teradata_Enterprise_0: There will be some skew in the usage of the server because the number of players (3) is no...

If you have a copy of the COBOL copybook, you can use readcobol (in the <your Ascential Root Dir>/DataStage/PXEngine/bin/ directory). That will convert the copybook to a schema which can then be imported into DataStage Manager (Import/Table Definitions/Orchestrate Table Definitions...). You can also...

Sounds like the column definition may not match the file exactly. Assuming this is an ASCII file with newline record delimiter, then the record-level and Field Default parameters look good. Double check your column definitions. The sum of the lengths of each field should total the overall record len...

How is the number of players related to the number of nodes? We have a number of different config files with node definitions ranging between 8 and 12 nodes. Here's a sample: { node "myserver" { fastname "myserver" pool "" resource disk "/mydir/DataStage_work/1&quo...

We recieve files from the mainframe that are complete extracts of DB2 tables. I don't know the specifics, but our mainframe people refer to a utility called DB2 Unload.

Hope this helps.

Sorry about the server vs. parallel forum, didn't realize where my message was being posted. Is it possible to move the posting? As for the player config, how do I specify how many players to use? We use DB2 and DataStage a lot, and I know that we have a configuration that was setup the described th...

I agree with Ray, do it in DataStage - if it isn't a standard database function, let something else do the work. In this case, converting EBCDIC to ASCII is not a normal database function, but it is normal for DataStage. Use the tool (or tools) most appropriate for the work to be done. Also, the ASC...

We have been using DS with DB2 for a long time and are now starting to use Teradata. I just created a simple program to test connectivity from our Teradata database. It is a read, using the Teradata Enterprise stage, to a dataset. I can read the table okay, but get the following warning in the log: ...

Is there such thing as a data model of the DataStage Universe database? I am especially interested in the tables containing job logs, but would prefer a complete model. Is there one out there? Even DDL would help.

I am running up to 12 concurrent instances of a parallel job. These are kicked off from CA Autosys (scheduler) and all logs need to be written out to files. How do I get the log summary and details of 1 specific instance/invocation? When I use dsjob -logsum to get the log summary, it returns the log...