DSXchange

akrzyzan,

I have the same issue. Did you find a solution?

I didn't read the thread thorough enough. sathyanveshi is using BASIC code to connect via ODBC...I'm getting the error using the ODBC stage within a Server job. Nothing fancy at all except for a user-defined SQL statement. My error is: DataStage Job 694 Phantom 16738 Warning: [DataDirect][ODBC SQL S...

Hi Ray, An Ascential consultant visited the premises and resolved this. I do not have exact idea as to what he did. Since DS was used across the organisation, he was called in by the IT Dept. head and he resolved it. I shall be contacting the Consultant and will get a detailed report of what he did...

Bump!!

Anyone out there with any experience with MySQL?

Ray thanks for your help. Really appreciate someone of your caliber coming to the rescue. I still got the same error: >DS_CONNECT MySQL_TESTING Enter username for connecting to 'MySQL_TESTING' DBMS [dsadm]: root Enter password for root: Abnormal termination of DataStage. Fault type is 4. Layer type ...

Ladies and Gentlemen, I've been trying to get this set up and it's impossible. I have DS 7x running on AIX 5.1. I wan't to connect to a remote machine running Linux and MySQL. I set up the uvodbc.config and .odbc.ini files correctly. When I try to import metadata in DS Designer is errors out like be...

These two jobs have been the most educational thus far in my Ascential learning process. Thank you all for your help. I was able to get the decimal and data type issue resolved by using two hash stages instead of a UV stage with a left join. Below is my final JOB 2. Again thank you and I hope to kee...

Craig,

I'll try your way of using purely hash stages and a lookup with a contraint and see if that takes care of my other problem...the decimal movement.

Thanks a lot. Have a good weekend.

Chullet, you hit the nail right on the head. I do have the 'Delete File before Create' option and the Create File option. I uncheckd both and now it works with the hash stage. thank you very much!!! But I'm having another problem that's related. If you look up to one of my first posts you will notic...

Well I tried changing it to a hash file instead of the UV stage, but now my Hash file only contains the records that went through the XFM as Not(NOTFOUND)'s. I wanted the hash file to contain the same amount of records that it had when it began. Since not all the records in the hash file are being u...

Thank you all for your help. Below is the final set-up for JOB 1:

I think I have answered my own question by searching this forum, but to be sure is it the UV stage?

I have tried updating the hash file as shown below, but as you all know there is no updating feature in the hash file stage. What stage do I use to update a hash file? HASH_UPDATE(HASH Stage) / OCI1 --> HASH / | / |/ OCI2 --> XFM --> OCI_BULK

Thanks Sainath, Ray, and Chuck. I'll try it in the morning.

My big question is how do I update the hash-file during a lookup against the same hash file?

I want to perform the lookup in JOB #1 and update the hash column PROCESSED to TRUE. Then I can use the same hash file in JOB 2 and look for the ones that have the column PROCESSED set to FALSE.