DSXchange

Hi, We are getting the below error when we are using & in the input file name. main_program: Received SIGPIPE signal caused by closing of the socket on port 13,400. No output will be sent to port 13,400 for the rest of the job. The job is showing no counts on the links and job monitor count is c...

Hi, I have a job which is loading using BAPI to SAP from an Oracle table. I want to run this job for every 1000 records in a sequential way several times. Is there any way to automate this in datastage. I do not want to run the job in multiple instance.For example if the Oracle table has 20050 recor...

If you do a "save as csv" in Excel you will get a comma separated file, and any columns that contain embedded commas will be double-quoted; so you will get a well-formed CSV file. You can read that in DataStage without a problem. Could you explain ...I tried to change the ',' in the file ...

Specify that the quote character as " (double quotes). Save it that way so that the comma within the data will not be considered a delimiter. You can save the file as tab delimited and then read with delimiter as 009. That should work. Tab delimited is not working as file is having space.Is th...

Hi, I am reading an xls file as .csv file. But, the file is having ',' as a valid value for some fields. I tried to change the ',' in the file to "|" but not able to do so because replace ',' with '|' is not working. I want to save the file in '|' delimited format. Is there any other way I...

Hi, We have 4000 char field. We want to pass only 132 char per line such that there will not be any break of words in between for example if at the end of the word 'Class' the length is 135 then the whole word will come in the next line.So the previous line will have only 130 characters. Currently t...

We havent been able to do that succeffully till now, and I am not sure if this is possible through DataStage. When you call a BAPI in DataStage (to load a set of records) - for each of the input record the BAPI is called. This hits the performance very hard. Moreover - there is a time out period, w...

Hi, When I am using Load option in Oracle Enterprise Stage I am getting the below error: The error is coming like this: Table_OUTPUT_LDR,9: The system(sqlldr load/*****@cnotl CONTROL=ora.1221018.874080.9.ctl LOG=ora.1221018.874080.9.log BAD=ora.1221018.874080.9.log.bad SILENT=header PARFILE=ora.1221...

The error is coming like this: Table_OUTPUT_LDR,9: The system(sqlldr load/*****@cnotl CONTROL=ora.1221018.874080.9.ctl LOG=ora.1221018.874080.9.log BAD=ora.1221018.874080.9.log.bad SILENT=header PARFILE=ora.1221018.874080.9.par) failed; see the log file for the Oracle specific message.his; With upse...

Is there any reason for failure. Of course there is, but *you* would need to tell *us* the reason. Post the actual errors that you get when the 'Load' option is used. The error is coming like this: Table_OUTPUT_LDR,9: The system(sqlldr load/*****@cnotl CONTROL=ora.1221018.874080.9.ctl LOG=ora.12210...

Is there any reason for failure. Of course there is, but *you* would need to tell *us* the reason. Post the actual errors that you get when the 'Load' option is used. The error is coming like this: SETPOINT_MASTER_OUTPUT_LDR,9: The system(sqlldr load/*****@cnotl CONTROL=ora.1221018.874080.9.ctl LOG...

Is there any reason for failure. Of course there is, but *you* would need to tell *us* the reason. Post the actual errors that you get when the 'Load' option is used. The error is coming like this: SETPOINT_MASTER_OUTPUT_LDR,9: The system(sqlldr load/*****@cnotl CONTROL=ora.1221018.874080.9.ctl LOG...

Hi, I am trying to load some records into an Oracle table using Oracle Enterprise stage as target. The job is running fine with Upsert option. when I am using Load the job is failing. Is there any reason for failure. There is no primary key or constraint in the table. The table is created from datas...

Hi, I am using SAP R/3 stages for loading into SAP. For BAPI stage we have import,export and table parameter. I am able to pass one record at a time for each of these three parameters. I am looking for passing one record to import and export parameters and multiple records in table parameters at one...

Thanks for the response.I was not having datastage in front of me. I have already got it after looking into datastage.I may face same situation in future. I can find the answer then with your reply. Closing this post as resolved.

Suman