DSXchange

The length of CHAR(10) is always 10, regardless of the contents. Convert your string to VarChar, use PadString, then convert back to Char.

devidotcom - yes, PX is quite picky about data types. But you haven't described your problems enough and therefore don't have responses. Your example shows delimited data, but the error message looks like a fixed width issue. Until you fix your metadata you won't be able to do anything with this file.

I assume you have VarChar2() columns. What load method for Oracle are you using?

I found an interesting post from THRobinson on this: Do you have MetaStage installed but not running? In other words, is the checkbox, in Administrator for this project under Properties, Operate in MetaStage Proxy mode checked but the Process MetaBroker daemon for it not running? You will then get t...

When I use a $Variable in a derivation in an EE transform stage I get a compiler error. Am I being obtuse this morning and missing something obvious (like a restriction in the documentation prohibiting this) or is it a bug - I've done a quick search here and couldn't find anything amongst the many p...

Anand - have you tried it? If you don't have the environment variable set you will get an error message.

Do you have an after-job subroutine? Also, if the counts are the same and the job is hanging, can you check to see if the UNIX processes associated with the job are still active? That would mean the job isn't really hanging but you are having an issue with updating the status.

Where and when are you getting the message? It doesn't look like a runtime error.

Your strings are badly formed. You can read the strings, declared without quotes, and then trim the leading and trailing quote characters in a transform stage, as DSGuru2B suggests.

What other stages do you have in your job? It is more likely "hanging" in one of those, particularly a database read, than in the dataset write. Have you checked the number of rows in the dataset when it hangs, and then compared it to the count when it runs without a problem?

If you simplify the job and read from the sequential stage and write to a sequential stage (use /dev/null as the output file) do you still get the same error? Oh, wait "DSD.Browse" -> this might be a corrupt internal metadata hashed file. There have been a lot of threads recently regarding broken pr...

You can use a stage variable to store the last ID and compare that with the current one to see if it has changed. Note that in an EE job you will need to partiiton on ID in order to ensure that this works correctly.

Looks good - is it not working as you expected?

Looks good - is it not working as you expected?

Luckily the Gartner group isn't worried yet. And since DataStage and Informatica use different approaches to creating ETL a feature-by-feature comparison is not very helpful and neither company pushes sales by the feature-function-benefit method anymore. Sure 8.0 FCS has bugs, some of them major; bu...