DSXchange

Hi Gurus, I was using the join type incorrect.But Now its ok, when i run this job, iam getting these error,please help me Gurus. ..Sequential_File_1.IDENT1: At row 2, link "DSLink4", while processing column "DEPTNO1" Value treated as NULL Attempt to convert String value "MGR...

Hi Gurus,
Still iam getting error, cannot open file1.Please help me Gurus.

cheers;
vijay

Hi Gurus, My sequential file location is c:\HashFiles\salma where salma is the name of the sequential file Another sequential file location is c:\Hashfiles\hash\vijay where vijay is the name of the another sequential file. when dealing with merge stage. First file directory path: c:\HashFiles second...

Hi Gurus,

Thanks very much Gurus.

cheers;
vijay

Hi, my design is MERGE----->ODBC. using merge stage iam merging 2 sequential files and dumping into database. i have declared the path of the sequential files as parameter. FIRST FILE DIRECTORY PATH: #$PATH_FILE# SECOND FILE DIRECTORY PATH: #$PATH_FILE1# I specified the first filename: vijay----> th...

Hi Gurus,
I copied the configuration file, where to edit to define the no of nodes assigned to particular process.

cheers;
vijay

Hi Gurus, My team is asking me to show how FTP works. I said to them that, basically inorder to work with FTP one needs mainframe environment, and it is mainly used to migrate files from one system to another. My database is oracle.How can i use FTP component and show them the way FTP works. cheers;...

Hi Gurus, One of my friend is using a parameter NAME PROMPT TYPE VALUE $DB TYPE ENTER THE DATABASE TYPE STRING $PROJDEF Please help me in analyzing the data, i was given task to analyze the parameters. what does the parameter DBTYPE indicates. Is that it shows that it is of dynamic rdbms type or any...

Hi Gurus,
How can i edit the configuration file.I allocated 4 nodes for a particular process, now i want to edit allocate only 2 nodes.I opened the configuration editor. I have checked the configuration file but how can i edit it. Please help me Gurus.

cheers;
vijay

Hi Gurus,
THANKS VERY MUCH.

cheers;
vijay

Hi, My company is upgrading from server to parallel, can anyone help me in parallel edition , what is the theory behind assigning no of nodes to a process. What i think is that if the no of nodes increases then load increases, so how can i determine the exact no of nodes required for a given process...

Hi Gurus,
I have created stage variable SET STATUS, and this stage variable now has a value. i want to give value contained in stage variable in some other job. Is it possible with datastage.

cheers;
vijay

Hi Gurus,
what is the command that lists all the parameters in a job from administrator.Is there any administrative command.

cheers;
vijay

Hi Gurus,
I can list the no of parameters used by DS PARAMINFO PROJECTNAME JOBNAME from the operating system.
But this is from the operating system, how should i loop this command for each and every parameter.
please help me to proceed further.

cheers;
vijay

Hi Gurus,
I tried a lt but couldn't comeup, Its only possible with gurus, please if any Guru helps me i will really appreciate.

cheers;
vijay