DSXchange

Hi All, Tried to search on the below query but did not get any convincing answers: I wanted to know what is impersonation mode and non-impersonation mode when installing DataStage on UNIX. I am not much well versed with UNIX... installation trying to know more about it. Any help on this please. Than...

Hi All,

I have a requirement to trim i.e, remove single quote ' and double quote " from a string.

How can I do this.
I tried the following

Trim (string,'"','A') and also Trim(string,''','A')

But this does not work.

Any help.

Thanks
Devi

Need to confirm on this

Hi All, In the DB2 stage if we have "Use Default Server" and "Use Default Database" options set to True then the environment variables "DB2INSTANCE" and "APT_DBNAME" are used respectively for server and database. Optionally either APT_DBNAME or DB2DBDFT for da...

You have an option of "Read from Multiple Nodes" or "Number of Readers per node".

Devi

Hi Ray,

Thank you for the reply.
I had did not run the dsenv file.

Ran the dsenv file now but it yet does not work. The $DB2INSTANCE variable is also set after that.
Any help on this.

Thanks
Devi

Hi All, I am trying to use the orchdbutil utility to each check if a table exists I get the following error. orchdbutil exists time_table -dbtype db2 -dbname dwh001 Ascential DataStage(tm) Enterprise Edition 7.5.1A Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Rights Reserved ##I...

Thank you for the reply.

Thank you for the reply. Noticed one more thing. When I saw the partitioning type of the reference link from the lookup fileset it says: "The currently selected link is a reference link from a lookup fileset stage or a stage thats uses a sparse lookup. There is no partitioning or collection pro...

We have certification for only Enterprise Edition (parallel). The cost is $75.

From one of Ray's post.. -------------------------------------------------------------------------------- Warning - Technical Content The reference input to a Lookup stage for a normal (not sparse) lookup causes a composite operator to be generated to perform two tasks, for which the operator names ...

Include the environment variable $APT_CONFIG_FILE in the job.

Yes it will.

Thanks for the inputs.
I guess I will try with the perl option and update the post.

One more thing. This webpage could have more than what I am looking for like some descriptions, image... etc I would have to eliminate them and then look for the data i want.

Hi All, I never used a lookup fileset. Tried doing a sample job... I created a lookup fileset using 5 columns with entire partition on it. Lets say the columns in lookup fileset our record {LUTVersion="1"} ( EMP_ID: int32; EMP_NAME: string[max=15] {dropped}; EMP_AGE: int32; EMP_ADDRESS: st...