DSXchange

Is it possible to setup an ODBC connection to MS Access databases from a UNIX version of DataStage?

Thanks a ton!
It worked well enough that although some of the Cities did not parse out of the address line, the state and zip code were enough to use to get the city later.

I'm sure there is a way to parse the field better. But this solves the problem well enough.

I am fairly new to using QualityStage and I've searched the forum for an answer but to no avail. I have to get an answer by tomorrow AM Eastern time or QualityStage will not be used. So, I'm looking to the gurus out there to provide some advice on this!! I have a single column field with several dif...

rjdickson wrote:Hi,

The radio buttons should become active when:
1. You select an existing match specification
2. The selected match specification is a 'Reference' match type

I hope that helps!

Thanks for the reply.. That worked!

Mike

I'm working with the Match Frequency stage and would like select Data Link Type. The Reference Link Type is currently selected when I drag and drop the stage into the job. The radio buttons are greyed out and I can't select Data Link Type.

Any ideas on how to enable the Link Type radio buttons?

I talked to IBM support and they informed me that using the same directory structure would not be feasible. In hindsight it doesn't make sense for several reasons. The biggest reason against this would be with respect to upgrades to new releases becoming logistical nightmares. This is thread should ...

Just to clarify.. I have a separate physical server that shares the same NAS containing the application software for my current physical server. I'm running RHEL 5. Is it possible to install the DataStage on the second physical server and 'share' the single instance of the application software? Woul...

I currently have a two tier DataStage 8.53 installation where entire software install (except the client) resides on HNAS. I would like to install a new DataStage engine on a separate server attached to the same HNAS directory tree. Is it possible/feasible to use the same DataStage application direc...

Maybe the logic should handle $RETURN_VALUE -eq 0 separately. This means that the job start request was successful and that the job is still running. You have no idea when it will end. Good point. #!/bin/ksh ################################################################################ # File Nam...

I now have the ODBC connection to Greenplum up and running.. You just need to ensure you're using the correct Driver library. .odbc.ini file... (I used the ip address of the host) [IDSGreenplum] Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMgplm24.so Description=IDS DataDirect 6.0 Gree...

Thanks Uncle Kim for the script.. I have stripped it down and added a flag. Still seems like the Job Activity should have a switch that disables the wait for finish. #!/bin/ksh ################################################################################ # File Name : RunJob.ksh # Description : r...

Routine is easy to write. You need to do a couple things to get parameters to work unless all jobs have the same parameter list. When you attach to a job you need to get the valid parameters for that job. Next you can only set a parameter that exists in the job you are about to run. I can probably ...

Use sub-sequences each with its own WaitForFile activity and Job activity. Ray- how would this be different from what I have currently designed? The job i'm calling from the master is a sequence with a Wait For File inside. The problem I'm having is that the master sequence will not invoke the subs...

Does the Loop have to wait for the Job Activity to finish even if I "fork" the flow to continue? So, File1 MUST complete before File2 is even processed. The Job Activity does a 'Wait for File' So, I don't mind the Master Sequence waiting for all the children to finish before it finishes; T...

I would like to iterate through a list of files and call a datastage job to process those files simultaneously using the filename as the invocation id. I have created a sequence that does this. However, the loop is currently waiting for the datastage job to complete before moving to the next file in...