DSXchange

Thanks to all Experts,

The suggestins by you were very apt and useful.
the issue is resolved and i can now source the dsenv file successfully.

thanks again.

regards,

hi, i did the :set nu in the vi mode on the dsen file. then i found that one line that has a path is split in two lines. i have posted it below. plz let me know what changes to be mad if this is the issue which needs to be fixed. +85 PATH=$PATH:/dsetlsoft/datastage/Ascential/DataStage/PXEngine.752.1...

Craig,

I am in doubt. what should i open in vi and do :set nu ?
and then wat should i check?

Sourcing of dsenv should be done in the path $DSHOME/DSEngine right?

regards,

Hi Experts, I am facing problem in sourcing the dsenv file with following error. ------------------------------------------------------------------------------------- # cd DSEngine # . ./dsenv ksh: t/datastage/Ascential/DataStage/DSEngine/bin:/dsetlsoft/datastage/Ascential/DataStage/PXEngine/bin:/or...

oh thanks Craig,

You mean i can delete the folder with unix rm command,
and if i have to delete individual datasets then i should go for orchadmin.

am i right?

regards,

hi, Actually i want to know if i could delete the whole folder at once instead of deleting datasets individually to save time. I need to create a fresh folder for datasets in another path. Also i am facing problem in sourcing the dsenv file with following error. -------------------------------------...

Hi Experts, I want to delete all the existing datasets. all the datasets are created in the Homepath in a folder called $DSHOME/Datasets. CAN i delete all the datasets by using the unix command rm *.* in the folder $DSHOME/Datasets ? Actually i want to create another folder in another path for datas...

hi,

Yes i did all kinds of searches but found no luck.
some workarrounds have been suggested like promoting the warning to info and using upsert instead of load.

regards,
vinayak.

Hi experts, i have the following warning in most of the load jobs[parallel]. Error: JOB_NAME: When checking operator: When validating export schema: Unrecognized top level format property: nocheck kindly let me know why this warning appears, and how to eliminate it. In some similar jobs it doesnt ap...

Hi Friends,

The issue is resolved now. i used to_char function to read the out put of the query and column datatype as varchar. this gave me the correct dates.

thanks experts. Your suggestions helped me.

regards,

Hi,

A sample of the output of the table view in datastage is as follows:

GDATU
---------
12152
12517
12882
13248

the query is mentioned above in the post. this is the internal format i am getting.

Hi, My job design is simple. OracleOCI --> Transformer -->Seq File. when i do right click on OracleOCI stage and view data, then it shows dates in internal format. when i view the dates in TOAD then maximum date that i get is 12-02-2009. So i put Oconv in transformer and loaded the dates to the file...

Hi experts, i am reading a date column from an oracle table and writing it to a file. its a very simple select query [select distinct doc_date as gdatu from VBAK_AR] i am using in the Oracle OCI stage. But when i read the dates using Oconv function [Oconv(DSLink25.GDATU,"D/DMY[2,2,4]")] i ...

Hi,
Q1 means that Cleanup resources option is not enabled. How to enable it so that i locks are visible when we select show all.

Q2) please let me know what how to go about enabling the lock daemon and setting the time.

thanks for your quick responses.

Hi,
Q1 means that Cleanup resources option is not enabled. How to enable it so that i locks are visible when we select show all.

Q2) please let me know what how to go about enabling the lock daemon and setting the time.

thanks for your quick responses.