DSXchange

Hi, I think you can do this. If you are using a transformer in the job, you can divert one flow to the Oracle stage with delete query and with the constraint @INROWNUM=1 to that flow, so that the rows will be deleted (i mean truncated, ie., in this case deletion followed by auto commit since deletio...

Hi, I think you can do this. If you are using a transformer in the job, you can divert one flow to the Oracle stage with delete query and with the constraint @INROWNUM=1 to that flow, so that the rows will be deleted (i mean truncated, ie., in this case deletion followed by auto commit since deletio...

Thank you All.

the issue got resolved with the following

StringToDate(Column_name,'dd-mmm-yy')

-Bhasan

Thank you all for the inputs.

i wonder if the format is like this 'dd-mon-yy' (for eg: '02-mar-09') then how to convert it into valid date?

I tried using StringtoDate(Column_name,'dd-mon-yy'). It is not converting properly.

Thanks in advance,

bhasan.

Hi, Is there any way to convert a string (dd-mm-yyyy) to date format. I think it is possible to convert a string which is in the format 'yyyy-mm-dd' to date easily using type conversion functions, but i need to convert the above string which is in the format 'dd-mm-yyyy' to date. For ex: '23-06-1999...

Hi,

May i know the significance of the following variables

DSWaitStartup
DSWaitResetStartup

I found these variables in dsenv file. These variables are set to some number.

Thanks in advance.

- Bhasan

Hi,

Thank you very much ray. Atlast am able to execute the commands of Orchadmin utility.

I had to set variable to LIBPATH pointing to the path where required ".so" file is existing.

This solved my problem.

So in total it resolved my doubts. Thanks a ton !!!

thanks,
Bhasan.

hi Srividya/chulett, thanks for your replies. after setting the PATH and APT_CONFIG_FILE variables, i executed the following command >orchadmin check Dataset1.ds >Could not load program orchadmin: Dependent module liborchgeneralaix3.so could not be loaded. Could not load module liborchgeneralaix3.so...

Hi Sainath,

Sorry. I did not get you.

Can you please be clear. Please don't think that i am testing your patience. am new to this. so asked you to say clearly.

Thanks,
Bhasan.

Hi Sainath,

Wheni am doing this

cd $DSHOME/dsenv

i got error as

/app/ascential/Ascential/DataStage/DSEngine/dsenv: not a directory

-Bhasan

Hi, at first i set the 'path' variable instead of PATH. now i set properly and then executed the following command orchadmin check <path/datasetname> it shown the following error: Could not load program orchadmin: Dependent module liborchgeneralaix3.so could not be loaded. Could not load module libo...

Hi,

Even after setting the path and APT_CONFIG_FILE, am getting the same errors as mentioned in the previous post.

Thanks,
Bhasan.

Hi chulett,

when i drop the $ sign, even then it is throwing the error as

ksh: orchadmin: not found.

Thanks,
Bhasan.

Hi, I am using the following orchadmin syntax $orchadmin <command> <options> <DatasetName> When i tried the following command it shown the following errors: $orchadmin check Data1.ds ksh: check: not found $orchadmin describe Data1.ds ksh: describe: not found I got the above errors even after setting...

Hi all, Am able to view the dataset data using Dataset management tool in Datastage Manager, but am unable to view the same using ORCHADMIN Utility. even after setting the APT_CONFIG_VALUE to proper .apt file. May i know how to view the dataset using Orchadmin Util commands and what are the steps to...