DSXchange

Hi, I need to pick up the max value that is generated by job1, and use it in job2? For job1 i have used KeyMgtGetNextValue('x'). for job2 can i use the KeyMgtGetMaxKey('x')? Any ideas Thanks in advance. Use the SetUserStatus function. FUNCTION SetUserStatus(ID) Call DSSetUserStatus(ID) Ans = ID RET...

I'm involved in converting legacy data from existing systems into a new implemementation of SAP. DataStage is being used to extract and transform the data and the load is accomplished via SAP utilities and load programs. We are using the following: DataStage Server edition 7.5.1A OS: Unix AIX 5.3 SA...

Use a 'select items from list' StartLoop activity in a job sequence. The list can be generated by any command/regular expression. Sorry for all the questions.....and thanks for the help... Here is the syntax that created the list.... ls FI_PS_C_034_Open930Construction_Load_* > /load/Ascential/DataS...

Apart from probably needing an extra job to process each detail file, to generate the value(s) for the summary, that's fairly close. A job sequence that contains a loop will help to construct the required files from the outputs of DS Job 3. Within the loop run DS Job 4 to calculate the summary for ...

That's my second post on this topic, my first answer (before yours) seems to have been ignored. Your first answer has not been ignored.... in fact, I've been getting my brain around the whole process and the two of you are making the picturer clearer, I hope. :lol: As you can tell, I'm a 'rookie' a...

Kevin, is the control, header and footer information a function of the data, i.e. can you change your processing to have one job create {n} files of 998 or less records without a header/control/footer and then a second process to add this missing information? The version, control, and header files ...

I am preparing a fixed width, CRLF text file for use by load programs into SAP R/3. The requirements are: 1. The file must have no more than 998 records 2. The first line must contain version information 3. The second line contains control information 4. The third contains header information 5. The ...