DSXchange

Hi,
I have columns with valuse as longitude and latitude.
we need to handle this in data stage as geographical datatype and not as varchar or char.
Could you pleae help on this


Thanks
Sudhir

Hi Ray,
thx for reply, please suggest the approach , it should be k if it invokes database query.

Hi, i am in need of unix command which can give us all job names and annotation in the job of a category. say i have three job in the folder /test/prjct1 j1ext j2tfm j3load if i pass argument to unix command as /test/prjct1 , i should get job names and annotation given in that job. Thx Sudhir

Hi,
Is MQ server needs to be installed on datastage 8.0 server to connect with MQ server on remote server(Mainframe).

Is MQ pluggin is enough for datastage 8.0 (installed on distributed server)to connect with MQ server on remote or we need MQ client on datastage 8.0 server?

can anyone please help.

Thanks Ernie, I have a MQ server which is on mainframe machine, can Infosphere MQ Server connect with the one which is at mainframe. Or both MQ server need to be on same machine.


Thanks
Sudhir

hi,
-- Can anyone please confirm that MQ Message Server is bulit in with Infosphere datastage 8.0 or 8.1? or Do we need to install it seperately?
-- we have plan to use MQ connector stage, does it need any internal configuration of that stage(MQ Message server)?

thks

sudhir

I have one requiement for real time data integration, whenever data gets changed at source level need to load to datawarehouse. I need to implement it through data satge job which checks for data change at source and trigger a job which loads data to datawarehouse.Have to take care of latency also a...

Have ds px job loading to Table, it gets aborted after loading some records. In next run how to make sure that only remaining rows get loaded without altering previous loaded records

Hi Looks like your ODBC drivers are not installed. "go to server/branded_odbc" and check whether the odbc drivers are installed Regards Sreeni Hi, Thx for replying Actually before ODBC stage sort and remove duplicates are used. when job is run with dataset inplace of ODBC stage it runs fi...

Following error message comes when ODBC stage is used for update only query

Fatal Error: Could not connect to datasourcereturn code -1 from SQLConnect(handle, 'Userid', 'password', 'Database') with message [DataDirect][ODBC lib] Specified driver could not be loaded


Can anyone help , please

Hi,
I am using Sequentuial file stage in server job. I need to capture all the records which are not matched with metadata ( data format such datatype, fixedlength property etc). after capturing all records the job should get abort.
Can anyone pls suggest , Is it possible in server job?