DSXchange

Could anyone please suggest how to call a SQL Server stored procedure which has no inputs and outputs?

Are there any surrounding warning messages. Run the job again for maybe 2 records and see if any more messages are there. Also try resetting the job, this brings some more info to the log file at time ... No other messages or warnings related to this are coming in the log even after i do reset. The...

Hi, Can anyone clarify why i'm getting this warning - "DataStage Job 1430 Phantom 7408". When i open this warning i'm seeing some thing like this.... DataStage Job 1430 Phantom 7408 Warning: [DataDirect][ODBC SQL Server Driver][SQL Server] Warning: [DataDirect][ODBC SQL Server Driver][SQL ...

This command worked for me but it is returning only one row in the output. Can u please tell me how to get all the rows in the input file to output file with changes? Now i'm using this command awk '{ gsub("<MYTAG>*.*</MYTAG>","<MYTAG></MYTAG>"); print $0}' filename1 > filename2 ...

Thanx. Sorry it didn't worked for me. My data is like this exactly <tag1>abcd</tag1><tag2>def</tag2><MYTAG>Hai</MYTAG><tag4>jhg</tag4> <tag1>abcd</tag1><tag2>def</tag2><MYTAG>Hello</MYTAG><tag4>jhg</tag4> In this data we should remove Hai and Hello. Thanks in advance,

Can any one help me out with an unix command which removes data between two tags...

<a>Hai</a>
<a>Hello</a>

I want Hai and Hello to be removed from this data. So the outpu should be

<a></a>
<a></a>

Thanks in advance,

Can any one help me out with an unix command which removes data between two tags...

<a>Hai</a>
<a>Hello</a>

I want Hai and Hello to be removed from this data. So the outpu should be

<a></a>
<a></a>

Thanks in advance,

Hi, I have a requirement in which there are about 4000 records in one file and 5212 records in another file. And i'm using merge stage to merge these two files on one id. But it is taking more time to load infact the datastage is strucking in the middle without giving even one error or warning. I wo...

ray.wurlod wrote:I'd be inclined to create a routine to be invoked from a Routine activity in which the list of addresses is read and composed into the Addressee field in the DSSendMail() function call. ...

How to read files from a Job Routine?

OK, I was afraid of that. In this case DS (both server and PX) have no way of knowing where to split the columns. The file is not machine-readable (unless you can guarantee that the string of `","` does not show up in the text and all columns are double-quote delimited. Have your program ...

In my case I just used a sequential file stage to read the file (DS Server interprets the ",," nullable input correctly) and then outputted a fixed width sequential that PX Server then reads. With an appropriate null pad character and fixed lengths the PX read is very easy to do. I'm not ...

thumsup9 wrote:What did you mention in you Quote Character under Format Tab in sequential file.

I have checked with " and 000 both. But it didn't worked. Could you help me with any other solution!

Hi, We are getting data in CSV files. These CSV files has "," as field delimiter and Quotes for the data as usual. But the data itself is coming with commas and quotes in between. And we should not change the csv files. But we should import the data successfully. So anyone can please help ...