DSXchange

Yeah, you just need to define metadata in sequential file give the file extension as .txt at end of file name and properties should be Fixedwidth Delimiter=none record delimited= newline and try to define metadata exactly as Data length and give data type as char so that is going to be fixed width f...

I think that option will not work for multiple selection, It will work for single job/folder selection, try in that way I don't think there is any way to move multiple jobs at single shot.

Hi,
Create a routine and call that to do the caluculation and change into required format.

Hi,
You have to split the task into couple of jobs like, one job will read the data and write into a sequential file and at the same time you can delete records by using other ;pipeline', and second job would be loading data into target so that it will not give any problems.

Hi,
The easy way is , Create a sequence with mutiple job activities and call the same job in all job activities with different invocations-ID's so that you can see different logs in director for different Invocation-IDs.

Hi,
Some times re starting the server would work for this kind of issues, other wise first logout all the sessions and kill all active sessions from unix and then try to run it, this solution would help some times becuase unix box is over loaded or more processers are running.

Hi, The easy and best way is , save values for SRC file name and Company name in a file and invoke the file in Datastage job or before starting the job you can read the file pass the values to those parameters on teh fly. either way you can follow read the file before triggering the job or read the ...

Hi Raj,
If you can pass business logic so that I can help you out.
as per your example: INput is 10 and Output is 1010
Does it mean what ever input is there you just need to concatinate the same value again to the input value , If you can explain it clearly I can help you out.

Are you working remote system, If yes then that might be the reason DS server is not able to establish connection with other source or TGT systems., try with one simple job like seq file to seq file keeping in the same DS server box, then you can identify the actual probelm. If the above case works ...

Hi, You can find by using DS command "DSTOOLS", there you can see all the options to view the locks and clear the locks. But still you need dsadmin previliges this can be done through DSadmin client or UNIX, there you can see all information about jobs. Actually some times in your case it ...

Hi, You can check your self , Is delimiter correct or not by checking view data. Once you are able to view Data properly then come to Target Mload stage and inside NLS tab check UTY option, try to change that or try to view data in TEXTPAD, so that you can find the Difference in Data. I am trying to...

Hi, We are trying to generate profile reports from PSDB data base!, we are able to generate analsis report but we are not able to provide sample data from PSDB data base, It seems Profile stage is loading all records into a table in CLOB format or in some other format .....!, But we are not able int...

Hi,
Can u tell me how to call profile stage jobs in command line prompt

If you are working on "information server" version 8 then its suite so there is no question to install profile stage separately. Its "installation issue" Try to change your NLS or code page settings. No, We are not using information analyser version 8, We are working with profil...

Hi, am quite sure its issue bcoz of NLS(National language Support) charcter set. Please check your NLS SETTINGS WHEN YOU INSTALL INFORMATION SERVER OR DATASTAGE, if you using languge other then english then you have to enable this NLS charcter SET but if you are using english charcter then you must...