DSXchange

have you had restart the ds server after changes have been made to dsenv ?

At times it works as dsenv will refresh values of all the variables.


Regards,
Nitin Swarnkar

Thanks Nitin. Is it necessary that the output columns should be in the same order like the input columns in the hash file? Also In order to remove that key column, do I need to include another transformer. Regards, Deepti Deepti, If you want to reorder the columns then you have to maintain their po...

It's necessary to have key column to be included in hashed file.

- Nitin

It's necessary to have key column to be included in hashed file.

- Nitin

TNS:listener could not resolve SID given in connect descriptor You are able to connect to Oracle through OCI stage, as you have TNS entry in tnsname.ora in you unix box, but connecting through ODBC, you need to mentioned following string in uvodbc.conifg file <db_handle> DBMSTYPE = ODBC and db_handl...

[quote="Virupan"]Hi,

How can I convert date format from 'yyyy-mm-dd' to 'yyyymmdd' format ?

You can delete " - " by using EREPLACE function

EREPLACE(columnName,"-","")

Nitin Swarnkar

Hi Ray,

I am just curious about "Open File limit" in the message.

Is it pertaining to "ulimit" parameter on Unix box or MFILE/TFILE at Datastage environment ?

In Manager also you can find the Date/time of last update in the job by changing the view as details.

In Manager also you can find the Date/time of last update in the job by changing the view as details.

Hi, I have a server job and have the target table as an oracle stage. I am doing inset/update (insert new rows or upsert existing rows). But still i am getting this oracle error ORA-00001: unique constraint (CVID_UAT.PK_CV_WE_PRE_INSPECT) violated Ideally we should not get this in an upsert mode, i...

[quote="bireswar.goswami"]Hi All,
I have to produce random no as customer id


Why you want to generate random number, to maintain Cust_Id to be unique or there is some other purpose ?

wfis wrote:But I do not get a window to save the report as pdf. Any help apprepicated.

Do you installed PDF writer (not reader) installed in your machine. If you have then you can save it in any format and then right click it, there you would have an option to convert it to PDF.

Hi, how to convert this into (13 NOV 2008 21:06) timestamp format Hi Laknar, first you have to convert it into internal format with help of Iconv Function. and then you can convert back this value to readable format by Oconv. Like Oconv(Iconv(Field_Name[1,11],"D"),"D/YMD[4,2,2]"...

venni wrote:Hi frnds,
I have small query...
I hav sorcu data like this..

a$a%d
b^f*g
g@j&*h

pls can any one tell me how to handle this special char's.

You can use Oconv function with "MCA" or "MCP" options to get Alpha-Numeric or Printable characters.

it seem like $PROJDEF doesn't resolve to value "bcuprod".[/quote]

While defining the parameter at Adminstrator, you have to provide the actual value of parameter and when you are using them in jobs then you can select the between $PROJDEF and $ENV.