DSXchange

Hi DS 8.7 on Window 2008 R2 We have Infosphere Information Server successfully installed and Datastage jobs are running fine. It has been installed in the default C drive on the server C:\IBM\InformationServer and the projects are under C:\IBM\InformationServer\Server\Projects,but since the C drive ...

I already tried breaking the procesess in multilpe parts..multiple jobs..but no effect as the the very first Select Query (join across 3 tables) that fetches the 4.5 M records takes about 6.5 Mins and everything else about 1.5 mins.. I created a simple job to fetch this data in a Copy stage at it ta...

Hi, DS 8.7 on Windows Server 2008 R2 (Dual Core, 64 GB RAM) Src and Tgt Database - SQL Server 2008 Currently we have a SP that inserts about 4.5 Million records everyday..It drops target table first, creates and inserts the data from a 3 table join query, then runs 3 different updates on this data (...

Let me walk you through my job design. I have 3 TD enterprise stages in one parallel job which run different queries parallely and i am combining the output using a funnel in a file. With your solution, the prob is, i will have to check the output for all the three queries and run them accordingly(s...

Thanks for the reply.

We have a process wherein sometimes this can happen that there are no rows to process. It may not happen always.
I need your help with this as i dont want to use message handlers

I have not seen such warnings with Oracle or ODBC stages.

hi, i am facing a similar issue. My DS is running on 4 nodes. I have specified 2 sessionperplayer and hence 8 requested sessions. stil i am getting this warning when there are no records to be fetched :

Delete,0: Query returned no results. No read will be performed.

jwiles, I had selected the File Pattern. It does not work with selecting Specific File option as well, which I guess is expected, as this is Not a File Name but a pattern I see similar post here for v8.5 and it says it is a bug and that IBM is to fix it, doesn't look like it has been :( http://www.d...

After adding the ENV Variable and setting it to True, the job runs successfully but does not read from the file, shows 0 records (I verified the file is present and has 45 records) It gives this warning message SEF_WNOACCS3_D34001: Fileset /tmp/import_tmp_729269132fb8.fs contains no files. If a file...

I tried without using the Env Variable (which seems to be more forparallelising the read in case of mulitple files by treating it as a FileSet) I added the option in the Seq File stage "File Name Column" and this is returning me the file name w/o the date part as \Path\abc*.Txt in a new ou...

Hi, I have a simple job that read data from oracle table and load into the hash file and I used the following query to read data in OCI stage. The datatype for column DATE_DT is date(19). "SELECT DW_DATE_ID,TO_CHAR(DATE_DT, 'YYYY-MM-DD HH24:MI:SS') FROM STG2D_DATE" In Datastage 8.0.1, when...

Hi, DS 8.7 on Windows We are using a File Pattern in a Sequential Stage as we get dated files abc_20120322.txt (We expect only 1 per day).. So reading and processing this file is not a problem but I want to know the exact name of the file so an email notification can be sent. How can I get this full...

The correct syntax is No Brackets for the parameter

Execute SPNAME 1;

It works fine after that!

We tried changing the datatype to Timestamp from date but, when we tried viewing the data it threw an error stating conversion failed. Since, we are using a user defined SQL as given SELECT DW_DATE_ID,TO_CHAR(DATE_DT, 'YY-MON-DD') FROM STG2D_DATE. We encountered this issue when we were migrating the...

Hi, DS 8.7 on Windows I am trying to call a SP (DB - SQL Server) with one Input Parameter (and it does not return anything) from the BeforeSQL part in the ODBC Connector stage but it throws this error I tried all these but it still fails Execute SPNAME(1) Exec SPNAME(1) Call SPNAME(1) Con_ODBC_Campu...

When we try to view data from Datastage OCI stage, the date is getting displayed in some internal format though the datatype is defined as date. ex. "20-MAR-2013" is displayed as 16516. when the query used in the above OCI stage is executed in toad we are getting the date in proper format ...