DSXchange

Roy is referring to something that I've heard called an 'Upsert'. Specifically (in Oracle for example) you can load your data into a temp table and then use the MERGE command to get new records and updates from the temp table to the target table by defining the join and telling it what to do when it...

Check the Basic.pdf documentation that was installed with your client software. It would be in the 'Docs' directory under your 'DataStage' directory. The description of the LOCATE function can be found there.

Please start a new thread rather than hijacking someone else's. Thanks.

One of the first things you need to learn when writing scripts for DataStage is - make no assumptions about anything. Specify full paths, beware of relative paths unless you know exactly where you are, don't assume environment variables are set, etc, etc. The environment a script runs under in DataS...

Please find the below log file content. It actually opens the port and successfully ftping the files. But the files are not getting copied into the local unix directory. A couple of points: 1) Your message 'script completed successfully' should be changed to 'script completed'. There's no check for...

Not really a DataStage problem, more of a configuration issue with your email server. Take a look at this Microsoft Knowledge Base article and see if it applies.

There seemed to be several other similar articles which a search there for your keywords should turn up.

Stopping and restarting. Going down and back up like a rubber ball, hence the term "bouncing".

the source stage facing this problem. i think is because of user id and pwd not correct..any ideas? It's got nothing to do with it being incorrect, that would generate a completely different error. It means that, as far as the stage is concerned, you've left the fields empty. And saying 'the source...

How about using a hex editor to view the file? Or perhaps 'od' on your UNIX server? You mentioned TextPad which is a Windows utility, how are you getting the file over to Windows? Bottom line - you need to figure out how it's getting in there. Are you sure it's not coming from your lookup hash?

Interesting... when I was testing on one of the SuperDome lpars with "too many" cpus I got the warning during installation and during every job run. Lucky you with the 'no warnings in my jobs' problem.

Don't think I should comment on your wacky admin.

Oh, it works all right - it just that every job finishes with at least one warning. In other words, no job ever gets a plain old 'Finished' status.

Or are you saying that it works differently under 7.5?

Unless the LF is in the data field in the hash file, I don't see how what you are doing would add one. I'd also suggest you not set that last case to 'null' if it's not one or two - unless you know it will never be used. If you concatenate null onto the end of a string, the whole string will become ...

You'll find you need permissions to both. Basically, the 'cron' command is used for recurring jobs and 'at' is used for those 'one time' job schedules.

Hi, (VALIDATIONS) SEQ_FILE--------->XFM------->SEQ_FILE(CLEAN DATA) | | V(ERR_CD) SEQ_FILE --->XFM------>SEQ_FILE(ERR_CD,ERR_DESC) ^ | | |(ERR_CD,ERR_DESC) hsh_file Iam creating a sequential file with the columns ERR_CD AND ERR_DESC. Iam getting the ERR_DESC ...

Exactly what it says - you are using a stage that has a property called 'User Id'. It is required that it have a value and you haven't provided one.

Which stage are you dealing with?