DSXchange

Hi all- Thanks for all your comments, definitely appreciated. So, does everyone agree that by changing the logic from ' ' to 0, it is no longer sending an error? I believe the error is still being sent out, because it is still showing me warnings for the job. The warnings haven't changed, so instead...

Ok, so I went into the actual routine and was able to get my job to run, by editing the routine. I took the one routine I was getting an abort error on (the routine was called ForceWarn), and I changed the Ans =' ' to be Ans= 0 in the physical routine, I compiled and tested it, and it seemed to work...

So, I tried to do what was mentioned here, but I am still getting an error, the error is now aborting me out of the Seq. this is what the error says, should I edit the GetNextBatchNumber Routine? The GlobalBatchName has a value of 'madhavi' and a CurrentBatchNum value of 0. CopyOfSEQ_J_Stage_PS_S_F0...

So, I tried to do what was mentioned here, but I am still getting an error, the error is now aborting me out of the Seq. this is what the error says, should I edit the GetNextBatchNumber Routine? The GlobalBatchName has a value of 'madhavi' and a CurrentBatchNum value of 0. CopyOfSEQ_J_Stage_PS_S_F0...

I am having warning issues when my datastage job is finished running. I checked the number of rows from source and it matches number of rows in target. I am using a variable in the job. That is probably why it says "variables" has been cleared. What should I do to not have those warning is...

This is the first time I've seen this error, but it's not the first time this error has come up.

Is it because the SID logic isn't working properly, or is it because there is a non-zero value being returned (as chulett mentioned)?

Hi Guru's I'm having a problem in my Job Sequencer, where I keep getting this error, "(@GetNextBatchNumber): Routine DSU.GetNextBatchNumber did not finish OK. " I'm also seeing this error with the GetMaxDateTime and GetMinDateTime. Do I need a patch to resolve this? Or would this be a resu...

Sorry, corrected my statement.

I got the patch and it is now working. Thanks!

When I double click the job activity in a sequencer to view the properties, the properties box doesn't come up. I don't have any problem double clicking for anything else. A co-worker said there is a fix for that problem but can't seem to find it.. Anyone can help to locate that fix?

I thought about using Stored Procedure...a co-worker suggested placing EXECUTE IMMEDIATE before each of the insert statement in quotes but getting Oracle error such as PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: := . ( @ % ; not null range default cha...

I am currently using Oracle database.... Mun... You didn't mention what database you are working with. You need to use command line database command to execute the SQLs kept in the file. For example in UDB, you can use a shell script (say loadtbl.sh) as follows: db2 connect to dbname user userid usi...

I have a SQL file that has about 200 insert SQL statements. How do I call it from DataStage as a Before-Job routine or After-job routine to get the file from repository and run that file and load data into the database? Currently, I have run the entire script in TOAD and execute as script and it pop...

Perfect!! You guys ROCK!!! :D

Hi,

I am trying to reverse first name and last name.

ie: Doe John -> John Doe
or Jane Mary -> Mary Jane