DSXchange

Please post the entire error, so we can determine which operator (or pair of operators) is generating it.

In the Administrator client you can set default date, time and timestamp formats for the project (and the default decimal placeholder character). It is these that are used if no format string is provided, for better or worse. The Transformer stage is documented in the Parallel Job Developer's Guide ...

You need to obtain the results of DSGetLinkInfo() and concatenate that into the string. The string that you pass to DSSendMail() will therefore have a generating expression of the form "From:xyz@abc.com\nTo:.pqr@abc.com\nserver:abc.com\nAttach:D:\Seq_reject.txt\nBody: %" :DSGetLinkInfo(...

Why not? You're expecting to get 200 rows in this case. The columns will only be visible within DataStage, nowhere else. If you were prepared to use a server job, you could use the multi-value handling and dynamic normalization capability of a hashed file to solve this for an arbitrary number of col...

I can recall being asked to install DataStage on a 286 processor with 4MB of memory because that was the "standard in-house configuration". Go the bean counters! IBM's recommendation would potentially need to be triplicated if you want HACMP plus 24x7 operation or, at the very least, to have all dis...

Is there a comma between the name and the list of scores? If so read the file as comma delimited and run it through a Pivot stage. If not, convert it to this format (maybe with a Transformer stage), re-parse it (maybe with a Column Input stage) and then run it through a Pivot stage.

As each "lookup" is performed in a Merge stage, the secondary record is consumed. This is documented behaviour and might be one of the reasons for using this stage type, to perform true master/update comparisons. That is why de-duplicated inputs are recommended. Sounds like you want a Lookup stage r...

Show us your actual code - in particular what you do with that string. I would suggest that at least some concatenation is in order to build the string.

Byte-sized records or megabyte-sized records or twelve-inch long-playing records? What do you want to do with those records?

This is an entirely unanswerable question.

My company wouldn't even make the Fortune 50000000 list!

1. Run a job that executes the procedure. You can run the job from your routine.

2. Code using the ODBC API, but beware that the DataDirect ODBC drivers supplied with DataStage are licensed only for use with DataStage stages.

3. Code using the Oracle API.

Is the HP-UX process table filling/full, preventing allocation of any more process IDs (pids)?

It's there, but may be disabled (greyed out). In that case you need to enable display of generated OSH using the Administrator client.

But, it occurred to me after I posted the previous post, that if it's Siebel that are changing the rules, then surely you should demand that it's they who should change your jobs. Does that seem fair?

OK. It can be done and fairly effiently. But it's still horrible. Perform a vertical pivot of your data to get the following columns, using stage variables as the pivoting technique. Group FN1 OV1 NV1 FN2 OV2 NV2 FN2 OV3 NV3 ----- --- --- --- --- --- --- --- --- --- B1 C1 a b C2 c d C3 e f Then use ...