DSXchange

From the log you supplied: Job JC_LD_T1_ICWIS_STAGING started with parameter parmParameterFile set to D:\DWH\Parameter_Files\MasterParameterFile_LoadsPreProcessing_DS3.txt Job JC_LD_T1_AG_PAYMENT started next, but appears not to have any parameters. Have you added the parameter parmParameterFile to ...

Either Roy or I need a name change!

Please, can someone give Roy some credit for some of my posts?

Specifically, you lack SELECT privilege on the system tables in which names of tables, views, columns and so on are stored. Negotiate with your DBA, pointing out that SELECT privilege alone can not engender any damage,

WRKRDBDIRE. How do you pronounce that?

Is 22. decimal or not?. It depends. There are no data types in DataStage server edition, so the data type depends on what you're doing with it. The value you cite could be an integer, a decimal, a floating point number or a character string, depending on the context. Further, the notion of data typ...

Trim(myDate) is illegal when myDate has data type Date. Similarly, StringToDate() expects a string argument, not a date argument. That's why I asked about data type. The next recommendation was going to be to change the data type to string (VarChar or Char) to see if that worked. Obviously it does.

To really scare you, if you want to add C functions to be callable via the GCI on UNIX, you have to re-build the executables (dssh/uvsh primarily).

Last time I looked, Windows XP is not an operating system on which DataStage is certified.

I think that the OP is seeking a routine that returns a flag that indicates whether a combination of day, month and year represents a valid date. It can be run from the Test grid or from within a job, etc. FUNCTION IsValidDate(Day, Month, Year) Ans = @NULL If UnAssigned(Day) Or UnAss...

LARGE.RECORD is a threshold value (either bytes or % of a group buffer size) where, if the record size is larger, some - maybe all - of the data in that record are stored in secondary group buffers dedicated exclusively to the storage of this oversized record's data, though the key is always stored ...

Separation is not relevant for dynamic hashed files, which is why you don't find it in HFC.

Group buffers in static hashed files are each (512 * separation) bytes in size.

Group buffers in dynamic hashed files are each (2048 * GROUP.SIZE) bytes in size.

The query optimizer will treat these queries identically.

Read all the information in the error report. In particular "Configuration does not contain the invoking node PUNACX010" tells you exactly what's wrong, which Sainath has correctly diagnosed. In the manual and/or in the training you will learn that fastname is the name of a network node, usually the...

Again it's an Oracle error not a DataStage error, though probably another missing environment variable such as LANG or NLS_LANG. Make sure these are set in dsenv file.
At the operating system prompt on the server execute the command oerr ORA 12705 - it might reveal additional information.

You can, in Director log view, set the filter (Ctrl-T) so that they're not displayed, but they will always be generated and always be in the log.