DSXchange

A couple of teensy corrections...

1) It's 'mkdbfile' with no dot in it.

2) CREATE.FILE is use in an 'Account' which is typically synonymous with the current Project.

Figured other parameters made up the entire filename. But are you still saying that the ROOT parameter only has a single value in any given environment? If so, I'm glad it's working for you as it wouldn't in our environment.

Not in my 7.5.1A version... it uses question marks, even when set to Oracle.

Doddle... doddle... hmm... <google google google> an easy task, child's play, cinch, duck soup, piece of cake, pushover, breeze, walkover, picnic, snap. Aha!

If I was on a machine with access to that information, I'd post it for ya - but I'll leave that up to ecclesr.

Ah... [sigh] I've not marked this as a Premium post initially but will change it to one 'shortly' - whatever that means.

While it's nice to be able to have the directory structures identical across dev, test and production it isn't really practical - or what you'll find out in the real world much of the time. For us, the 'dev' and 'test' projects and file areas are all on one machine, so they cannot be the same. I've ...

Really can't tell you how to read them on a Windows server, don't know. However, you don't necessarily need to read anything - you can just check for the presence of certain files that are only created when Something Goes Wrong. The *.bad file springs to mind.

Meaning, rather than using OConv - send it the output from IConv.

The ODBC parameter markers aren't quite as... flexible... as the numbered ones the OCI stage uses. The numbered ones can be used more than once in a query, while the '?' markers cannot as they are purely positional. Meaning, if you have 10 columns you can only have 10 parameter markers and they are ...

Assuming you are using the official DB2 stage, from what I recall from reading posts here that particular stage wants the date in internal format.

Let me save you a whole lot of grief and cut right to the head of the class - download ETLStats from Kim Duke's DataStage Tips page. Done.

ArndW wrote:The FTP stage in DS has the advantage that it transmits the data row-by-row.

Some would consider that a disadvantage.

Ah... good eye, Mr Kim.

Final score in the 'Wildcards in the Sequential File stage' Bowl Game: PX 1, Server 0.

All you should have to do, as part of your upgrade, is to edit your dsenv file to point to the 10g client rather than the 9i client. Shouldn't be anything more to it than that, from what I recall.