DSXchange

I have just seen my first phantom error!!! Ohh how excited I am...well not realy. I cant find any documentation on this error. Any one have an Idea what phantom error 948 means?
Jim

I am in the middle of testing this...It seems to work. This tool has many diff ways to do one thing...Im still trying to figure out wich is the best. Jim quote: Originally posted by roy [br]Hi, Just wanted to point out that as far as you specified the logic you need can simply be done with stage var...

I am looking at this and I get alot of it. Do you know of a reasource where i can decode some of the functions that you used like the @AM and the useage of the # sighn? Jim quote: Originally posted by kcbland [br]Here's a sample of how you could construct your DS function in Manager. In a nutshell, ...

I need you to eliaberate on your idea of putting this in a table in the db. Why does it cry to be put into a table? You said that my SQL only needed a few tweeks. Can you point me in the direrction of an example so that I can tweek my code? Regards Jim quote: Originally posted by kcbland [br]This is...

What I am trying to do is a complex update statment on a server setup this is the code quote: [br] Update DW_JOC_ALL_IMP_DATA_TBL Set Sub_Trade = Case When -- (PACIFIC TRADE GENERAL): (COUNTRY IN ('588','570','580','582','583','560','559','549','565','557','552', '538','555','579','566','546','574',...

I have taken the class..but my instructor just breezed over the sql part saying that it could be done in a routine and that was that realy thats why i am soo lost Jim quote: Originally posted by Ray.Wurlod [br]Enrol in the DataStage Essentials class. This will equip you with the knowledge you seek. ...

The DS Function...I know that I cant use native SQL in that. Is there any good source for a tutorial or a help guide in writing Datastage Basic? Jim quote: Originally posted by kcbland [br]You select from the target table and create a file of your rows that you want to process. Derive the updated va...

I need to do an update to a coloumn in a table. Its a SQL case statment that idetifies my companies trade lanes. I want to do this transfrom as I pump the data into a stage table. I was told to do this in the derivation of the coloumn. Is this true? how on earth does that work? Can any one give me a...

I may be out of my leage here but...why are you using a dupication of the info as a look up. why not just create a lookup of just the keys. it will be much faster to look up than looking up against the full record. give that a thought Jim quote: Originally posted by jseclen [br]Hi Xiong, You must co...

Looking up the Keys in the hash file is where i am lost. Ill E mail you a zip file with a word doc that contains a screan shot of my transfromation. I think that I am trying to think one way when the tool needs me to think another way. If you get a chance could you look and tell me what my problem i...

Im looking into using hash files for the referencial checking, but I am having a problem in the transfromation. My world says that for me to find whats missing from the refrence table i need to compare the two files, the newly created hash file of all the values in the data vrs the reference table t...

Ohh How i love user forums!!!! I will have to go over the hash file stuff again, only touched on it in the class....as for the sql stuff....a user defined stage as part of any stage? Im kinda lost there, what key words should I look under for more info in help? Jim quote: Originally posted by kduke ...

I was under the impresion that I could take a SQL statment, like an Update statment and put that into a Routine in Data Stage and use it in a transformation. When I try to complile the routine i get the error:Compiling: Source = 'DSU_BP/DSU.JOCImportTradeDefines', Object = 'DSU_BP.O/DSU.JOCImportTra...

Ok i have just worked and finished a job that pumps data into a table in my SQL server. Now i need to do some work to the table. I need to derive some info using some SQL code, and i need to maintain Referencial integrity before i promote the info from the stage table to the production table. The qu...

quote: Originally posted by Neena [br]Hi as ray said Before the job runs, execute this command (perhaps through a before-job subroutine invoking ExecDOS): type file1 file2 > file3 or copy A+B C both woks to merge two files in to one Neena ....I finaly got what John was saying to work. Now the questi...