DSXchange

A professionally done job would have not used this stage or these features. I would have written a generic library of reusable scripts and avoided the FTP stage altogether. I'd use ssh and scp to satisfy security concerns, as well as promote a faster file transfer (dedicated transfer with optional p...

You need to get the specific version of DataStage for your operating system release. Your CD only works with the OS you purchased. You need new CDs and licensing information for Unix variants.

How could this possibly work? Data is positional, with DML you're preparing a cursor and feeding values to a cursor. With bulk loading, you're loading a fixed file. You can't do what you're asking. You need to separate your output data into different subsets of rows, each with like record type. Each...

Easiest way to do this is on initialization of a Stage Variable in a Transformer. Write a DS Function to do a CALL DSExecute and run the command to get the filename and format the results. This will only be done once when the stage starts. Set the derivation of the stage variable to itself (FRED = F...

Your metadata is wrong. Re-import the metadata and use that. If the messages continue, then you have to figure out which columns don't match the data. Sometimes metadata shows no decimal scale, but the actual data contains decimals. You'll have to set the decimal scale manually in the job to give yo...

A piece of friendly advice, represent your problem with actual rows and columns. Show exact source data and exact expected data. Your example shows a comma delimited string in the expected results. If this is not what you're asked, then show your example more clearly.

Oh Ernie, you got me. I ignored the capital letters and made a poor assumption that the poster was asking a simpler question about DS BASIC. Well, my answer is to select all derivations for change, right-click choose Derivation Substition, and then type into the "Regular expression to match" field a...

Sort the data, use Stage Variables and collect the data in there concatenating the pertinent columns, reset the stage variables on key column changes, pass to an Aggregator and use the LAST derivation for the concatentated data, group by the key columns.

If you're using Link Collectors or IPC stages, timeouts will occur occasionally. It's a choice you make when you use these stages. Unless there's balanced and constantly streaming input to these stages, a timeout may occur. There's no way to prevent a timeout, because timeouts can't be disabled. Any...

Welome to the forum. The expressions are simply assignment operations. If you need to do a conditional, an If-Then-Else statement works. I suggest you open existing jobs written by others and look and the various methods for writing BASIC expressions. As a programmer, you should have no problem unde...

MKS toolkit only applies to Windoze versions. Is it a fresh instalation or an upgrade? Just read the installation documents and readme notes for your version, make sure your kernel settings are in place ahead of time. The best advice is have the support number handy, because they're your first line ...

You will still want to configure different node pools, in case you wish some jobs to use fewer resources and other jobs to use more.

Nodes are not assigned to a processor in no fashion, no way, no how. This is bad information. You are creating a logical computer when you create the configuration file. You could configure 100 nodes on a single cpu server if you were so included. You could configure 10 nodes on a 256 cpu server as ...

Operating systems govern what processes run on which cpus and what resources are allocated. The most you could do is run jobs under different userids and (if your hardware supports affinity) define cpu affinity for userids. That will at least set aside cpus for different users, but there's no way to...

Are your dates formatted to YYYY-MM-DD?