DSXchange

No, not specifically. Should be ok to put in the DataStage Enterprise Edition forum unless someone thinks there is a more appropriate place...

Small confusion Please help me JOB ID and JOB NO Same ? No, they are not. JOB ID is something I've never had an occassion to use but from what I remember is a user-defined ID that you manually assign to a particular job. Then dsjob can start the job by name or ID. This is also different from the @I...

multiple spaces will occur either first name,last name,middle name.some times multiple spaces may be occur at a time in middle and first,last names. People provided code because your original problem definition was finite - one word first name, one word last name with only the 'middle name' possibl...

You might want to search again as that is not a space issue, it is a resource issue and it has been discussed here quite a number of times.

"Can not open the file that contains the SQL statement" is your issue. You've told the stage to get its SQL from a file and it can't find it.

Have you looked into the SCD stage?

So, that gets it to a timestamp. What is your target's data type? What output are you currently getting? If you need a particular format, convert it back to a string.

Make sure you understand that there is no reason to delete just the descriptor files, all that will do is orphan the actual datasets they are associated with. As noted, for "bulk" deletes you can script a do loop to run the orchadmin rm command for a list of .ds files with whatever age cri...

The batch job could very easily get the current date and pass it as a parameter... or you could rename the file after job. Both ways are perfectly valid.

... and don't be confused by the Merge stage which will join two sources provided both are flat files.

Informatica is in their 9.x release cycle so there's no way IBM could stick with a smaller number for IIS / DataStage... everybody knows 9 is greater than 8!

Which 8.x release are you running?

Crazy I know, but stuff like this is documented. For example, here or in the matching pdf... look for the Record Prefix bullet point. Pay particular attention to the 'mutually exclusive' statement as that should help clear up their purpose. Note that there is lots of information out there for the go...

An exact search here for your message will reveal many conversations on the topic, i.e. what it means and how to handle it.

ray.wurlod wrote:You did not state that in your original questions. I can only read minds at short range.

Always suspected... now confirmed.