DSXchange

Put that one user in a separate operating system group, and assign the DataStage Operator role to that group. If required, check "allow Operator to view full log" in Administrator.

Can do either at the moment. Just tried it on 7.5.1 and the Routines are there in the export file (and can be imported). Try this export file

The run that had the failure had a buffering problem (shortage of memory? I/O device?) - the run that did not have the failure also did not have the buffering problem. These intermittent faults are the hardest to diagnose!

It's not an error, it's an alert message. If you define a node pool called "export", whether or not you are in a grid environment, any export operator (for example a Sequential File stage that has an input link) will execute in that node pool. You are being alerted to the fact that your configuratio...

What stage type are you using? If it's a left outer join, you should be getting NULL as the return from the right input. You need some downstream processing to convert these NULLs to whatever replacement value you desire.

BigInt and Int are treated as the same in DataStage BASIC.

Treat the column as VarChar.

It can be done, as follows. When you import, choose Import Selected option button. The entire DSX file will be read into memory, but not imported. You can then select the individual component(s) you wish to import, before clicking the Import button. Note that executables may have been exported separ...

Apply a StringToDate conversion (with appropriate format specification) to convert the string to a date data type. Then apply a DateToTimestamp function.

Change() is a subset of Ereplace(). Search, therefore, for a parallel equivalent of Ereplace(). Its author is DSGuru2B.

That's probably because you moved the server Pivot stage into your Palette.

DSXchange has a wee problem now that QualityStage and DataStage share the same Designer. For now, however, I'd continue to recommend posting QualityStage questions in the QualityStage forum, and DataStage questions in the Server or Enterprise Edition DataStage fora. Posting in both QualityStage and...

There is a configurable limit to the PRECISION (number of significant digits) in DataStage BASIC. What happens when you use SSub( string1 , string2 ) function, where the two arguments are your two numbers? This is an example of DataStage's "string math" functions, which can be used to get around pre...

No idea at all. BigInt and Int are treated as the same in DataStage BASIC. Is any of the values larger than 2^31-1 (which might cause an arithmetic overflow in an Int data type)?

In DataStage BASIC SEEK filevariable , offset , location postitions the file pointer offset characters away from location , and offset can be negative or positive. For location 0 means current location, 1 means beginning of file and 2 means end of file. If the file is not too big to read as a single...