DSXchange

Hi All, We did install datastage 8.0 and datastage 7.5 on citrix machine using AIE ( Application Isolation Environment). However when users try to access datastage 7.5 from their network id's, it does not work for few specific users and these users are seeing datastage 6.0 flash screen. We never ins...

Yes Craig. Really really long and mutiple joins, sub queries etc. I started migrating existing jobs from 7.5.2 to 8.1 recently and i faced the same issue. I don't know who wrote the SQL (it was written by some X). So i ended up in doing R&D to find out where the issue is... After minutes of str...

simple query like : SELECT RECOG_REVENUE_USD_AMOUNT, NON_DEFER_REVENUE_USD_AMOUNT, SPREAD_USD_AMOUNT, FC_SPREAD_AMOUNT, CORP_FLAG, EXIS_WATERFALL_SPREAD_USD_AMT, NEW_SPREAD_USD_AMOUNT, BACKBILL_PICKUP_SPREAD_USD_AMT, CATCHUP_SPREAD_USD_AMOUNT, UNRECOG_SPREAD_USD_AMOUNT, EXT_STANDARD_USD_PRICE, EXT_S...

ray.wurlod wrote:Get your Oracle DBA to monitor the session associated with the running DataStage job and, in particular, the SQL statement that is received in that session.

The job is not running more than 15 sec. It fails as soon as I start it. DBA didnt find any active session for this SQL.

Get your Oracle DBA to monitor the session and, in particular, the SQL statement that is received in that session. Compare that with the SQL statement reported in the DataStage job log. Figure out any differences. I copied sql statement from DS logs and passed it to DBA, they are able to run the sa...

I am having a complex user defined query, which is fetching data from many tables having nested query. My datastage job is as below: oracle stage -> transformer -> oracle stage in source oracle stage, I am reading the data using above user defined query. this query runs fine if I fire it in toad. My...

Hi All, I am using "como on filename.txt" to save the output of commands in the administrator. when I go and check the the same in project directory, it is showing me results but whenever the filesize crosses around 22-23kb, it truncates the remaining results. I am searching whole project ...

Thanks a lot :D

Hi All,

I wish to save the result of dataStage administrator command line to a text file. Is it possible??

I understand that I can write a unix shell script to output the dssh results to a text file, but this is extra effort all the time.

Thanks and Regards,
Surendra Kumar Sharma

Hi All, Given a job name, can I find out where the job is used in the sequence? We are having a sequence, which is having around 1000 jobs and there are many recursive sequences. There are many jobs which are not even used in the sequence. I need to find out if a job is used in the sequence or not. ...

Double quotes within double quotes (the "@RECORD" in the EVAL clause. Try using single quotes around @RECORD since the SQL statement itself is already within double quotes. ../../DSEngine/bin/dssh "SELECT NAME FMT '35L', CATEGORY FMT '35L' FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO ...

Double quotes within double quotes (the "@RECORD" in the EVAL clause. Try using single quotes around @RECORD since the SQL statement itself is already within double quotes. ../../DSEngine/bin/dssh "SELECT NAME FMT '35L', CATEGORY FMT '35L' FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO ...

The SQL query is syntactically valid. Please show us how you are trying to use it from the shell script. I am trying to fetch all the jobnames and categories to a file which are using table "ABC", following is the script: cd `cat /.dshome` . ./dsenv cd /etl/apps/ds752/Ascential/DataStage/...

The LOGTO does happen but then exits and only then is the second statement is issued, which defeats the purpose. You need to do multiple commands in the same session. As Arnd noted, if you 'cd' to the project in question before launching the shell, the LOGTO is automatic. That way you're down to a ...

Hi I am running few commands on unix $cd `cat /.dshome` $. ./dsenv $bin/dssh >LOGTO <project_name> >SELECT * FROM DS_JOBS ( here I am running few datastage shell commands.) This is giving me the expected results. This stuff I need to use in a shell script, so I created following shell script $cd `ca...