DSXchange

The permissions are given at the project level to the groups on the system(OS). Don't think that you can set the permission at the job level.

My first assumption is that the server is running out of resources and is unable to spawn new processes associated with the running of the DataStage jobs. Is this not correct, are there other potential reasons for this error? Moreover, may be One of the sub task say Hashed File population for the l...

Can it be done in ODBC-stage OR Stored procedure stage ? Yes it can be done with ODBC stage. I my case also stored procedure stage shows Oracle only. How to call proc1(input_col2,...input_colN,...input_col1) to receive ResultSet (Output limk) ? Select Stored procedure and provide Stored procedure n...

Use Timestamp(19)

Hi, I checked the manager. The "nulltozero" should be in the "Transforms" folder but in my current project, it's empty. I don't know how it got deleted! I am not able to import the inbuilt transforms from other project. (read only). Any other way? TIA Create a copy of the Transf...

Thanks John, But I couldnt find much info abt the dsexport in the doc. Singhald, I just told you a example. We are having nearly 12000 jobs in our project. Out of that I have to export 200 jobs and this would not be a one time process, we have to do this frequently. That's why I thought of doing a ...

May be you can use two different links (writing to the same file)

For One Link
Use First Condition
For Invalid Name

For the Other Link
Use Second Condition
For Invalid Gender

In this way, if both the condition are met, the row is output to both of the link, that's what you want, may be

Hey may be its risky, use it at your own risk If you want to create a parent directory named ABCD use: INSERT INTO DS_JOBS(NAME,READONLY,CATEGORY) VALUES ('\\\ABCD','NRO','ABCD') If a sub directory named ABC under ABCD use: INSERT INTO DS_JOBS(NAME,READONLY,CATEGORY) VALUES ('\\\ABCD\ABC','NRO','ABC...

Use
viewtopic.php?t=91995&highlight=-1006

Hi, I am trying to import metadata frm schema but am not able to see the synonyms created in the schema from the other schema.. say for example i have 2 schemas a,b i have created a public synonym in 'a' for a table of 'b'..tried to import the same table def from 'a'(which i have access to in DS).....

(not exactly the same record.Some fields from those records are not the same but required fields are same)

Looks like you are talking about a Join (for that use user defined sql query). Please provide some more information about what do you want to do?

Thank you all, Kenneth and Arnd. Thanks for your replies

Hi All, I have a question related with the column length that we specify for varchar columns for Hashed Files. I have a Hashed File which is of more than 20 fields, all fields are having datatypes as varchars, The size of some fields is more than even 4000 characters. But I don't have exact idea abo...

As a work around you would need to use the same Hashed file as a lookup If lookup fails then only you would be writing to the Hashed file. Hashed File | V SRC------------------------> TRNS-------------->Hashed File Moreover don't check the Allow stage write to cache when writing to the Hashed file a...

I suppose you have specified like 'Value3' or 'Value4' in the lookup condition for column 2. Actually it is a logical condition which results into true (1) or false(0). What is actually happening is like its trying to match Col2 with either 0 or 1 (which you don't want). For your case you would need...