DSXchange

Don't you mean dsenv? Or maybe uvodbc.config? There's nothing in uvconfig pertinent to accessing Oracle remotely.

These are Visual Basic errors; that is, the problem is occurring in your client. "Cannot create object" may be caused by insufficient memory. Reinstalling the client may help; closing some other Windows applications may also help. Runtime error 91, however, is definitely a bug in the code; you shoul...

"I know what you're thinking, punk," hissed Wordy Harry to his new editor, "you're thinking, 'Did he use six superfluous adjectives or only five?' -- and to tell the truth, I forgot myself in all this excitement; but being as this is English, the most powerful language in the world, whose subtle nu...

No one can, because there isn't one.

DataStage allows you to map three roles to operating system groups (production manager role, developer role, operator role). That's all there is. You can read about these in the Administrator Guide.

What do you mean by "listener"?

Why not use grep as the filter command in a Sequential File stage - this will deliver just the required rows directly into a job, and you can then process just those rows into the target. No need for code that has to be maintained.

... for some particular value of truth, anyway.

If it matched input metadata it wouldn't be a reject from a Sequential File stage! You may require additional reject links in your downstream processing, for example to detect out of range values, lookup failures and the like.

Spell check doesn't pick up misplaced apostrophes, or those who use the term "sequencer" when they mean "job sequence", or those who use the term "hash file" instead of "hashed file". Grrr!

Apostrophe Man

... or they may be registry entries nowadays - who knows what "they" did for 7.5x2? Though I couldn't find any likely candidates on a registry search (using regedt32).

There are 1900 and 1970 epoch Transforms in the SDK. DateGenericToDaysSince1900 DateGenericToDaysSince1970 You actually need the reverse of these, to calculate the date that is so many seconds since 1900-01-01 00:00:00 You can convert seconds to days by dividing by 86400. If all you want is the date...

Static metadata certainly makes the DataStage stuff much easier to do.

Did you restart DataStage services after effecting these changes?

Are the changes reflected in the .operator.adm and .developer.adm hidden files in the project folder on the server? That is, were your changes successfully saved?

PS Does your nick imply Air Force?

Create a rejects link on your Sequential File stage and direct these rows where you will. At some point you will need to convert the raw record to a string for ongoing processing. The message reports that the value is 36000. This is fine for int32 and even for int16. What is the data type of this co...

Look at the SDK routines - there's processing available there for GMT. You do have to know your timezone to convert. And be aware of summer time shifts.

Yuk! Format the code (in DataStage) then edit the post with the code. Replace the code with the formatted code surrounded by Code tags.