DSXchange

With such large row sizes, the default separation of a Type 18 hashed file will be counterproductive. Check to see what your separation figure is set to, and then try 16, which will give you 8KB per page. (The default is 1KB, but converting from Type 30 may have given a default of 2KB, but even that...

Yes, but its absence will cause the framework to insert a tsort operator in any case, unless you use input link sorting on the Join stage. Because the Join stage requires sorted input, DataStage makes sure it can "see" something - directly on the input link - that guarantees sorted data. Better, I f...

I can't envisage any way that that post could be described as a DSXchange Testimonial.

Please post in the correct forum (General).

Before you do, you might consider a Search of DSXchange just in case the question has already been asked and answered.

Premium membership is inexpensive, at less than 30c (Rs12) per day. if you had premium membership you would be able to read my entire reply, and get other benefits as well. All revenue from premium membership is devoted to defraying hosting and bandwidth costs incurred by DSXchange. So, by taking p...

How (that is, by what method) do you propose to execute a mainframe DB2 stored procedure from DataStage parallel job?

I don't see any problem mentioned in the Oracle sqlldr log file.

Can you please post the full and exact message of any warning or error message in the DataStage job log itself? Also, is there anything in the sqlldr "bad" file?

This Pickwiki posting has a number of useful date functions using Iconv()/Oconv(). GetDateFormat - return: true if International format (dd/mm/yy) is set. GetElapsedPeriod - return: elapsed years @am months @am days GetElapsedTime - return: difference in seconds GetElapsedTime.toString - return: oco...

I am not aware of any mechanism that allows for this level of protection. Project-level is the only security mechanism inherent in DataStage. You can certainly prevent them from changing your job without changing its name, but this does not prevent them from opening or renaming the job. About the on...

svHour Field(InLink.TheString, ":", 1, 1) svMinSec Field(Field(InLink.TheString, ":", 2, 2), " ", 1, 1) svSuffix Field(InLink.TheString, " ", 2, 1) (If svSuffix = "AM" Then svHour Else svHour + 12) : ":&q...

The easiest complete approach is to use the Schema File property in the Sequential File stage, and set is value to a file that properly represents the record schema of the file that the generic job processes.

Since it's Windows, append Char(13):Char(10), or @FM will also probably work.

From memory, the macro invokes DSGetProjectInfo().

All DS Macro definitions are in the JOBCONTROL.H header file in DSINCLUDE.

Right now I am not in a position to be able to check.

I'm still not certain what the original question means. Is it, perhaps, an interview question that you have faced?

It IS OK to assign to any variable (which is all Ans is) many times in a routine. My routines certainly do.

Set the value returned from the script in a job parameter.