DSXchange

Hi I have a requirement to join a subset of data. Below is the design Flat file | | Oracle------>LKP------>DS Example I have to join on ID (present in oracle and Flat File) Values for ID in Oracle Values in Flat file 123 3 456 5 we need to get the two rwos in the output, Subset of data in falt file ...

Hi Chullet, Thanks for the reply. I cant use a server job. I can create a job and load it to a flat file but autosys needs to run the job every 30 min. I dont think Autosys will work calling the job and every 30 min and stop running it after it see a Y in the table. I dont have a script so looking f...

Hi, We have a requirement to start the jobs only the users update a column to 'Y' in a table. Can you tell me how can we achieve this. On every last day of the month our business team updates a column in a table to 'Y' then our autosys job needs to run. I think file watcher will work for Datastage j...

Hi I need to truncate the table and load the same table using Enterprise stage. We used Oracle connector stage which worked fine with no issues, but recently we faced an issue in the data having accented charcters. We changed the NLS and it worked for accented characters. Connector stage does not ha...

Yes Ray, when we run manually from SQL Server studio it works fine with no issues.

I have an extract job which reads it from SQL Server and loads into a Dataset. We are using ODBC stage for reading the SQL server. We are calling a simple stored proc from ODBC and it works fine, now when we have temp tables in the stored proc its getting aborted with no reason. It says columns not ...

Thanks for the reply. Its just a command we are using to go to the log folder and pick the log file that we need to attach. When we run the sequencer, i think the log file is not fiully created before we pick the file and email it. So the issue is we are not getting the entire log.

Hi, I have a requirement saying that I need to send an email if the sequencer fail. below is the design for exception handling Excpetion Handler-----> script to pick up the ds execute log file----->email notifiction. But when i run i am getting only half of the log file. Can someone help me. I need ...

Try importing the table definition using Orchestrate orchdbutil facility, which is known to be more accurate. Hi, I am also facing the same error. I have straight forward job Dataset ------> Copy---------->Oracle Table. I am using Oracle Connector stage. My source is Bigint and the target is Intege...

I think you are reaching the maximum user processeses. Try increasing the maximum user processeses. You can check using the below command
lsattr -E -l sys0.

Hope it helps.

chulett wrote:Let us know if this helps.

Simply awesome. Thanks a lot Chullet. It worked for me.

Thanks,

I am using 8.1 but still i dont see any.

Can you tell how to use it?

Hi,

Like Oracle, can we read a select stetement from from a file in DB2.
I have a select statement in a file and I need to read that file and develop a ETL job.

Can someone please advice?

Thanks

Hi,

The issue is resolved. There is one more job which is overwriting this dataset when running through sequencer. The other job is also in the same sequencer which is running parallely. So thats why when we are running it individually its running fine.

Thanks for your help.

Hi asorrel, Thank you for your reply, We are running with 2 node configuration. I am getting the error in both the nodes node1 and node2. I pasted the node2 error and similarly i am getting the same error for node1 also. We have 75 jobs with 75 different datasets. We are having issue with only one d...