DSXchange

Paperless office.

You are using one of the SDK functions. Take a look at its source code and see what it expects. The SDK functions have their own idiosyncratic definition for the format of a timestamp. Copy that routine, and adapt it to your own requirements.

Have you configured the uvodbc.config file in the project or the one in the DSEngine directory? Try configuring both.

Just put a parameterized WHERE clause in your extraction stage, on the Selection tab.

WHERE eff_date BETWEEN '#DateFrom#' AND '#DateTo#'

Should still be possible. Get the date of the first of next month from the three components: Year = (If Month = 12 Then Year + 1 Else Year) Month = (If Month = 12 Then 1 Else Month + 1) Day = 1 Build these into a date, and use a DateDiff function to calculate the date of the day prior. (I'm not full...

This can be really simple - bumped into one yesterday, failing to connect to Oracle in a different time zone, where they were doing the database backups, so had quiesced the database. Or it can be complex. Ultimately you have to discern why something is timing out.

We all get to hack it anew in Hawk!

Could you not design this as a Lookup stage with three reference inputs, each of which has a conditional lookup based on the value of A.col2? Set your condition not met rule to Continue at least for the first two, if not all three.

While not an active user of direct osh, I agree with the assessment that it's unlikely to go away any time soon; that judgment is based on my understanding of the DataStage architecture, which remains 100% reliant upon the parallel execution technology acquired from Torrent Systems. The only maybe i...

DataStage can certainly generate the data file(s) and control execution of your load script.

Welcome aboard! :D That a question that really would take too long to answer. Basically you're looking at how much of the data (both strings and patterns) you know, and how much QS can not handle. On this basis you might create new rules or rule overrides. In the patterns, specific tokens such as ^ ...

Welcome aboard.

Go to ibm.ascential.com and do a search for JD Edwards. The answer is yes, and quite a few places are doing this. A search on this forum would be helpful also.

Read more (in Help, or in the DataStage BASIC manual) about the MD conversion. Perhaps this will aid you in understanding how the different specifications you use differ from each other.

Why me particularly?

If it works, it's good. It may not be best, but it is good.