DSXchange

Hi call a unix script from datastage job(from before job subroutine) by passing the parameter like <projecetname> <jobname> <stagename> <linkname> script should contain the following command. dsjob -linkinfo <projecetname> <jobname> <stagename> <linkname> |head -1 | awk '{ print $5 }'>/path/outputfi...

sorry i have missed one more Error Line : ##E IIS-DSEE-TFDM-00093 15:19:42(001) <main_program> The file identified as '/Path1/datasetfiles/out_Dataset.ds.dsadm.servername.0000.0003.0000.2c82.cb422922.0003.afff8327' is not an ORCHESTRATE Data Set descriptor. ##I IIS-DSEE-TCOA-00022 15:19:42(002) <mai...

Once you start down the "manual deletion" path (and thus destroyed any automated mechanism) it seems you'll have to walk that manual path to its end. At this point you would just use rm to "cle ... That means , Only solution to clear the memory in the above case is i.e :we must have ...

Thanks MK, I got an idea from your answer why this error i am getting now. as it is an orphan it is giving error and no way to recover it. but my goal is to clear the memory. Here is the command you are asking for: ( i have used this command in the script) previously before deleting the .ds file fro...

ray.wurlod wrote:Restore the *.ds file from backup and delete the Data Set properly.

If you don't have a backup then shame on you. ...

Sorry for the misinterpretation

*.ds is the intermediate file. While running datastage it is created.

There are 2 ways of cleaning up datasets: 1)Go to datastage Management Utility through director and clean up. 2)Search for orchadmin command in datastage. Thanks for the Answer. but If source file is there then there is no problem ,i can delete from orchadmin command or through dataset manager . In...

Hi, I am creating all dataset files through my datastage job in a working Location:/Path1/datasetfiles/ File path for datasets in congiguration file :/path2 Could someone please tell me how to clear the memory of the datasets location mensioned in configuration file(/path2) ,if the original dataset ...

Hi, I am trying to insert a varchar field with only one space to the oracle table which is not null field through OCI stage . As it is not a empty string rather it is a varchar field with one space ,should be able to insert into oracle not null field. i think this field is being treated as null and ...

Is there any other way to achieve tat reference link column in Constraint.

Hi, I need a solution for one of my requirement, which is as follows: 1. I have a Look up table In which I have column named as "Profit Center". 2. I have a reference table in which I have two columns "Valfrom" and "Valto" 3. I need to specify a condition in Lookup stag...

As u mentioned that your target is sequential file,

1. Go to "Format" tab.
2.Right click on "find Defaults".
You need to specify ADD SUBPROPERTY--->"Null field Value" to '0' then the records won't get dropped.


Regards
Prasanna Lakshmi

Hi, I have an issue in the lookup stage. In Lookup table I have column1 and in reference table I have column2,column3 and column4. I need to specify a condition in lookupstage that column1 lies in between Column2 and column3 then retrieve column4 from reference table into the target. How do I specif...

Hi,

How do I read a Db2 table record count into a job parameter in datastage?

Regards
Prasanna

We are using DB2 API stage. Configuration has been set properly. When I use those Environmental variables I am able to view the data from Datastage in DB2 source. But no records are passing to target.

I have declared Environment Variables SERVERNAME,USERID and PASSWORD. When I use them in my Data Stage job as #$SERVERNAME#,#$USERID# and #$PASSWORD#, I am getting the following error message DB2_UDB_API_2,0: Fatal Error: Fatal: [IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009 Unabl...