DSXchange

Hi Ray, basically i was having issues with Oracle stage - with permissions but meanwhile i wanted to run the same job with using ODBC stage, there also i got the issues. I raised a ticket to DBA to look into this and he gave 775 on all the Oracle files - so the issues got resolved for Oracle and OD...

Define "performance" in an ETL context. Rows/sec is almost totally meaningless (search forum for my reasons). It really depends on how good the ODBC driver is how close it gets to a native driver. As a general rule, however, ODBC needs an extra layer of software (driver manager) as well a...

Not sure why you would even consider using a 'generic' stage like ODBC over a 'native' stage for any database unless you had absolutely no other choice. And 'absolutely no other choice' basically means there is no native stage available for your database. You would lose any Oracle-specific function...

Because it's REQUIRED and the expensive product your company purchased does not work without them - what the heck else does he 'need' to know? And it's just select privileges, for heaven's sake, not truncate or rearrange or randomize that you need. I really don't understand DBAs that get all pucker...

Because it's REQUIRED and the expensive product your company purchased does not work without them - what the heck else does he 'need' to know? And it's just select privileges, for heaven's sake, not truncate or rearrange or randomize that you need. I really don't understand DBAs that get all pucker...

to check if the table and its related objects exists or not. Hi Keshav, Thanks for your reply. I told my DBA the same thing what u have told. But he is not convinced with this to give me the select privileges. Could you please help me to provide valid reason so that I can convince DBA to get these ...

Hi, can someone help in resolving the following error. Oracle_Enterprise_0: APT_OraInstanceSet::opsInstalled(): prepare failed for query `select count(*) from sys.gv_$instance '; please have the DBA run the following command: grant select on sys.gv_$instance to public. I am getting this error while ...

Hi, I am trying to connect database through ODBC. Following configurations are done: 1. Defined uvodbc.config in DSHOME aswell as Project directory 2. Defined .odbc.ini in DSHOME directory 3. Defined odbc entry in dsenv file as : a). ODBCINF=/dspx00/Ascential/DataStage/branded_odbc; export ODBCINF b...

ray.wurlod wrote:The environment variables in Administrator are listed in the DSParams file in your project directory on the server. Edit this file to add SHLIB_PATH and your issue will be resolved.

Thanks Ray

Set SHLIB_PATH in the dsenv script. Thanks Roy. That setting i have done in dsenv file. But I am not getting SHLIB_PATH in environmental list of the project in datastage administrator. I am getting LD_LIBRARY_PATH .I am not getting any edit option to edit that variable. Is there any other way to do...

Hi,

After installing datastage on HP UX , I am not able to get SHLIB_PATH in Environmental variable list. But I am getting LD_LIBRARY_PATH.

Please help to resolve this.

Thanks,
Param

chulett wrote:Interesting... I''ve always used 'Case 2' without issue regardless of database server location.

Thanks Roy and Chulett for your information.
Even in case 2, what is the Service ? Is it database name ?

Thanks,
Param

Hi, I want to configure uvodbc.config file. Entries in sample uvodbc.config file is as given below: **************case 1************** <ODBC Name> DBMSTYPE = ODBC network = TCP/IP service = XXXX host = XXXX ***************case 2***************** <ODBC Name> DBMSTYPE = ODBC **************************...

Design it using a sequence job. Have an execute command stage spit out the value using "cat". Then just perform a Field() function to get the first column and similarly the second column. Be sure to use CONVERT() for the second column to get rid of the field marker "@FM". Perfor...

Hi,

I have a job which is creating a file with 2 columns . File contains 1 record only. Data in the file is 2007-04-12,2006.
I need to pass these value to FIVE different jobs as parameter.

How should I design the job to get this requirement.

Thanks in advance,
Param.