DSXchange

Thank ray, I understand the steps to be followed are 1) Stop DataStage 2) Stop the ASB agent 3) Stop Websphere Application Server 4) Stop the database instance for the XMETA repository Back up the server 5) Start the database instance for the XMETA repository 6) Start Websphere Application Server 7...

Hi, in administrator enable "add checkpoints so sequence is restartable on failure" in Project Properties/sequence tab and enable "Automatically handle activities that fail" either of the things may help you to solve, I used to compile the job which is aborted and i had run the s...

Hi All, I am getting following warnings in one of my job, where i am using default nls name: ISO8859-1 due to this warning, datas are rejected DSD.BCIPut call to OCONV failed. Column: "Column Name", NLS mapname: ISO8859-1, Column data (after conversion): ?20816288, Column data (in hex, bef...

Pass in yesterday's date as a job parameter. Use it in both the ExecSH call and the Sequential File stage. ... thanks for your reply, but I need some more input on how to get previous date as the parameter please trigger some ideas I can get yesterday's date in a stagevariable using the code: Oconv...

Exactly, simply put the full path to the script in the Input Values field along with any parameters if needed. And you can use job parameters in any portion of that. If needed. ... In my script I am saving the wordcounts of CSV files to /opt/IBM/count_<<yesterdays date>.txt and i need to call this ...

Hi All, I want to know how to call the shell script using ExecSH (before job subroutine) my script is in the path /opt/IBM/test.ksh Also i want to find the materials regarding the commands for ExecTCL that can be used in datastage. any suggestions and guidance will be most welcome. thanks in advance

Hi all, This is production error, job has been running successfully but I am getting this error whereas some other jobs are running in parallel OpenPath failed for - 0403-030 The fork function failed. Too many processes already exist.): DSD.BCIOpenR call to OCONV failed. DSD.BCIClose call to SQLDisc...

Hi All, I am facing the below problem in production now-a-days in one of the sequence, getting aborted for the following error Controller problem: Error calling DSRunJob(Job name), code=-99 [General repository interface 'other error'] Note: Job is running when it is compiled and run separetly but th...

Hi all, I am getting the following error while importing the datastage components. first time it has taken more than 30 hrs to import so i manually cancelled the import , then i tried to import the same dsx file and overwrite the existing jobs but during this error window appears and my import got c...

Or just use a double-quoted name in the Table field. ... Hi Ray, double-quoted name in the table field means where do you mean to say, in ODBC stage or SQL table structure? I tried in ODBC stage its not accepting quotes in column name as well as in the derivation field. Andrews idea works but I wan...

It sounds like you have embedded spaces as Ray surmised. You will need to quote them in order to have DataStage use them correctly. ... So where I should do this, at database level or datastage level. what I have understood is the quotes should be give in the table in sql database. Is that right? o...

Table names containing space characters have to be quoted. Is yours? ... Hi Ray, I do not have sql installed in my machine, I have the access to import the table definition from the sql server, when i am doing this I cannot able to view the data, its throwing error like as follows.. DSBrowser..ODBC...

Hi all, I want to fetch data from sql server database and load it in oracle database. But sql server database has the table with fields having space between., like, Policy No Number Item code Number while trying to fetch the data from sql server I am unable to fetch the data and I am not able to vie...

Now I need to check if the records coming from source are present in my LookUp. If yes I need to take forward the corresponding fields also from the Lookup reocrds. Here when I order By the Lookup records by Policy Number (Which is numeric DataType) I get the Lookup logic correct i.e. if records ar...

Now I need to check if the records coming from source are present in my LookUp. If yes I need to take forward the corresponding fields also from the Lookup reocrds. Here when I order By the Lookup records by Policy Number (Which is numeric DataType) I get the Lookup logic correct i.e. if records ar...