DSXchange

Is there anyone you work with that is familiar with handling EBCDIC files and all they bring to the table in an ASCII world and can help you? They don't need to know DataStage, that's the part you bring. So... the packed decimals are fine but the character fields have issues? I still think you shoul...

Never heard of the "vmf" file extension and searches only turn up game or media related usage. :? So... since you mentioned EBCDIC and packed decimal, I assume this is from a mainframe, yes? And if so that typically means COBOL and you should have an "FD" or File Description for ...

The "creating files" part would have been good to mention right up front.

I'm disputing your "need" for integer and asked if you'd actually tried to use the DECIMAL metadata as is in a job. If so, what was the issue / problem you found?

What stage are you using? One of them (from what I recall) had a "treat warning as error" in the past, not sure if that still exists.

Sounds like a support question to me. Not sure if anyone here would know that but I guess we'll see.

I'm assuming this is an unbound number in Oracle, yes? One with no precision specified. Have you actually tried using the metadata as imported or just assuming the worst? It should work fine, I'll wager.

The patch mentioned by rkashyap above perhaps?

Just wanted to add that "successfully" in the previous post is in quotes because that is something that is (somewhat? mostly? entirely?) specific to Oracle. It's been a long time since I've worked with other databases but there have been others where an update that effects zero records is ...

It issues an SQL update. When the keys match existing records they will be updated, when it doesn't (i.e. new data) the update will "successfully" update zero records.

ShaneMuir wrote:I can never remember if DCount returns the delimiter count or the column count

From the documentation:

Use the DCOUNT function to return the number of delimited fields in a data string

FYI - changed your subject to match your actual situation more better. From "position" to "occurrence".

What happens if you add the "/D domain" parameter before the host name?

Not quite following. Seems to me you could just number them yourself seeing as how there is always three. Yes? Or does the number change? In that case it might be as simple as counting the commas (add 1) but I think we'd need something more specific as to what exactly it is you need to do.

Thanks for stopping by Vincent! Always appreciated. :D