DSXchange

Hi Everyone, I have two jobs A and B . B should be execute after A finsihes and the job B will create a dummy file on unix server. I created a sequence job C which has A-->B .I have a requirement to 1) execute the sequence job C . 2)Interrogate for the existence of dummy file. 3)If the file doesnot ...

Hi Everyone, I have tried all the option you have said .. But still not able to avoid the warnings.. I have tried by putting the NULL Filed value as '000' . Is there any way can we set in sequential file stage format tab to avoid the warnings rather than removing the control M characters from comman...

Hi Iam pulling a file through sftp from a VMS remote system to datastage Unix server. I have tried in the sftp script to pull the file using ascii mode but still the file has got control M characters on unix box.And when i run the datastage job to load in to table all the records are loading but wit...

Hi , The output of the command od -c got 0425340 6 T H A V E E | S E A T T L 0425360 E | W A | 9 8 1 1 2 - 5 2 1 1 | 0425400 | | | | | | | | * 0425440 P r e - R e g i s t e r e d | 0425460 | | | | | | | | 0425500 \r \n \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 0425520 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \...

Thanks for your replys.

But you know iam pulling the file through an automated script and placing it on datastage server . And further using in a job.. So how can do this..

I would really appreciate your help..


Thanks

Hi, I have searched the forum before posting this message and have tried all the options suggested. But still unable to remove the warning. Iam loading data from a sequential file to a table . The format of the file i have put is Record Levl: Final Delimeter :End/None Field Defaults: Delimeter : | Q...

Hi, Thanks for your reply.. I have used your script but still iam not able to get that. Iam trying to execute using following commands so please let me know where iam going wrong. Remote server file name : FILE-02-16-2009. Here is the script #/usr/bin/ksh sftp username@ipaddress <<EOF lcd /etl/Proje...

Hi , I have a requirement to pull the file from remote server out side network and place it on datastage server. Once after getting the file i need to remove that file on the remote server , so that the next day also there will be only one file with name file* . Then this file should be used to load...

Hi, Ray -- My apology for the wrong information i gave .. We do have DB2 stages in the palette but DB2 EE stage is not configured. Perhaps our DB2 tables are not partitioned. My admin is working on configuring the DB2 EE stage . So if i use the DB2 EE stage how will that effect the parallel read (si...

Hi, I was trying to delete the table definition and folder related to that table definition but its throwing an error Unable to delete the item(s). unable to delete c2e76d84.26220332.30fff9.11eff5da956.24568d.9956a Ascential.DataStage.RepositoryView.OperationManager.OperationException: Unable to del...

Hi Thanks for your reply .. But we dont have DB2 native stage to use.. So by using the DRS or ODBC EE stage how to read the data in parallel and improve the performance..

Hi Everyone, I have a simple that extracts data from DB2 database and loads in to sql server.Iam using DRS stage for both the source and target databases. The job is taking 12 minutes of time to process 2 million of records. I would like to bring down the processing time under 8 minutes . I wonde wh...

Hi Everyone, We have datastage process that needs to start once after finishing some other process on different server. Lets say process 1 on server A and process 2 ( Datastage ) on Server B. Once the process 1 finishes they will update one of their target table with the current date. Then i need to...

Hi Everyone.. I have 40 sequence jobs that has to run concurrently .. when i try to run all the jobs,some of the jobs are aborting ..But when i run them individually all are finising successfully. I have searched the forum and found the information about the memory and cpu utilization . By using the...

Hi,

Is this is something i need to do by playing with array size and transaction size or need to ask admin ?
Any suggestions Please..