DSXchange

I created a user defined parameter in the administratot and ran the job but the NLSPATH didnt appear in the director when it ran. Hence i added parameter in the job and tried to run the job its prompting for the NLSpath. How does the $ENV get its value, whether it needs to be defined in unix box. Si...

In in your input column, select a dummy column, Name - Dummy value - '1'.
When the sequence is generated - use the below query
select seq.nextval, '1' dummy1 from dual

Now you can use the dummy column as key column in transformer

regards
Magesh S

The other sequences within the project will not be affected by recreating the hashfile. suppose there are two sequence in a project Seq1 and Seq2, and if we change Seq1 and recreate the hashfile, Seq2 will also be created without the changed values(since we are not deleting the Seq2 from the file fo...

Good to know that there is a command to execute, can you please give the full synax of trace comman

I have tested your script with 20000 rows its working fine, can you tell how much big is ur file

Magesh S

thanks for the reply, we have created another project and imported all the jobs in the new project and deleted the current project, the issue got resolved.

The issue with administrator was with every one


Magesh S

Please use the following code, which split the files and changes the output file with the required format TEMP_FILENAME="U_D-1_$DATE_YYYYMMDD"_ TEMP_DATA="NED1_DATA" ##Split the File split -a 4 $WORKDIR/NED1.csv $WORKDIR/$TEMP_DATA ##Move all the Filename that has been created wh...

you can open the sequence file, this file is a hashed file and will be available under projects/<your project name>, the name of file is SDKSequences. To access the file create a job and use a hashed stage, create two columns with varchar(10), check the first column as key, then write the detail to ...

Hi

I am getting this warning whenever i open the director: WARNING: Repository Interface Tracing is switched ON.

When i tried to log into administrator and choose the projects, when the properties button is pressed, then its giving the Runtime error '6'


any suggestions

Magesh S

We have a job which selects data from Oracle and pass through transform(there is no transform done just input is fed into output) and writes to a sequential file. When the number of rows from the query is more than 10M, then the job terminates without giving any meaningful error message. When we spl...

you can use the status function to check the how the Openseq was executed based on which you can overwrite the seq file

the possible return values are 0 - successful, 1 - failed to open

Check in the transformer of your job, You are trying to divide some variable with zero, check the rows fetched by the source

Hi

Some one has deleted the path environment variable from windows, which can be seen in System Properties of my computer. we recreated with the path of oracle and datastageand it started working

Magesh S

Can you please tell what is the equivalent file of dsenv in windows OS. we are using 5.2 in windows OS, when we opened the oracle stage, its giving ds_loadlibrary: Win32 error in LoadLibrary of oraoci8.dll - The specified module could not be found Can you please suggest where we need to put the orac...

Hi
thank you , checked create and delete option, the job got completed
Magesh S