DSXchange

Known bug, contact tech support. There is a support document G10056 on the Ascential website you can use to verify this bug. Good luck! -Ken --- Sas Tino wrote: > Hi, > > platform : UNIX-SOLARIS 8 > datastage : 5.1 > ORACLE : 8.1.7 > > Ive got the following problem. > I have multiple inputfiles and ...

Hi, platform : UNIX-SOLARIS 8 datastage : 5.1 ORACLE : 8.1.7 Ive got the following problem. I have multiple inputfiles and I process them one by one by executing a flow of jobs. Without any reason a job aborts leaving no message. When I see the log there is only 3 lines Start job x Job x aborted SEQ...

The problem is solved now, it was something with the SDKSequences file in the projectfolder that appears to be manditory. But Ive still got another question: anyone knows what a/ ot the VOC-file is? -----Oorspronkelijk bericht----- Van: Dommelen van W. (Wim) [mailto:Wim.van.Dommelen@NL.Fortis.com] V...

Hi, I get this error while running a job... any idea what might be the problem? DataStage Job 400 Phantom 13915 "SDKSequences" is already in your VOC file as a file definition record. File name = Attempting to Cleanup after ABORT raised in stage CreatingLogRecord..SetValues DataStage Phantom Abortin...

Thanks Bruce. Can Oracle be a bit more specific? We use array size > 1 all the time with the ORAOCI8 plugin through the Oracle 8 client inserting/updating to Oracle 9i (9.2.0.1.0). Although we have a 1Gbit connection to the database, the mere presence of the network connection requires us to use arr...

Hi All, -- Info from Oracle Support The ORA 600 error is coming when Array Size is > 1. As we are using OCI8 plugin to load Oracle 9i DB, this error is due to code incompatibility (internal to DataStage) Thanks, Bruce > --- David Barham wrote: > > Thanks for that. Im out of ideas for now. > > Hopefu...

Sorry, I forgot (it was so long ago). The pivot stage is not installed by default. It is an extra package you have to install. The instructions (subject to a little common sense interpretation) can be found on your DataStage installation CD at DataStage PackagesPlugin StagesDOCSENUPivot.pdf That doc...

Basically, your diagram is right. The input to the pivot will have a key plus 20 columns the output from the pivot will be 20 rows for each input row where each row has a key plus one column. The transformer stage then only needs one lookup as it only has one column per row to process. No routines a...

See reply to this question on Tools4DataStage:
http://www.tools4datastage.com/forum/to ... C_ID=84671
--
__________________________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup

CareerBuilder.com has over 400,000 jobs. Be smarter about your job search
http://corp.mail.com/careers

Duke. What i found out was that because the Hashkey 4 is a char, the job fails. Now what i have also noticed is that if there are no quotes around DSLink128.OFYWSS it fails. why it does this i dont know. when i tried it with just the first 3 keys which are all numeric, i did not have any problems. b...

Tunde Should these be: HashKey1 = Arg2 HashKey2 = Arg3 HashKey3 = Arg4 HashKey4 = Arg5 If that does not work then: HashLookupRoutine(hsh_getcode, "5", "30", DSLink128.E1COMP, DSLink128.OFYWSS, "1") Otherwise: Make sure hsh_getcode exists in: "/apps/etl/Ascential/DataStage/Projects/td_edw/HASHFILES/"...

I did make the changes you recommended but i got the same error. Here is how im calling the routine from DS_transformer. HashLookupRoutine(hsh_getcode,5, 30, DSLink128.E1COMP, DSLink128.OFYWSS, 1) and here is what it comes back as DataStage Job 55 Phantom 24011 Program "DSU.HashLookupRoutine": Line ...

Tunde I am going to have to send you a bill. HashFileName does not have a value. You are trying to open the directory. *HashTable = Arg1 HashTable = "/apps/etl/Ascential/DataStage/Projects/td_edw/HASHFILES/" : HashFileName Should be: HashTable = Arg1 HashTable = "/apps/etl/Ascential/DataStage/Projec...

This routine now works except that when i access it thru a transforma, it fails the job sending out the this error message DataStage Job 55 Phantom 21181 Program "DSU.HashLookupRoutine": Line 63, Improper data type. Attempting to Cleanup after ABORT raised in stage LoadFinSlsNew..T_identifiers DataS...

Udo, Here is a link to the DataDirect website regarding this topic. m A second link there will take you to a Ken North report with metrics comparing the two for both the version 8 and 9 OCI. Regards, Kevin -----Original Message----- From: udo.neumann@eds.com [mailto:udo.neumann@eds.com] Sent: Tuesda...