DSXchange

hi Guys/Gals, I have an Pl/SQL stored procedure and I need to create a job ( not just by calling it in a Stored procedure stage) to do the same thing as the stored procedure. the stored procedure is opening 2 nested cursors in oracle and use the first 5 rows and update a table oracle. my questions a...

ya but if you are passing nulls to a fixed width file, i am not sure how the file will look like when you are reading that sequential file, you can still tell DataStage how you represented nulls in your sequential file, and it can read your file accordingly, for example lets say you replaced null f...

if you use null handling, you will be able to view the data in the seq file.

Thank you all for all the responses, yes simply resetting and rerunning jobs solve the problem most of the time but when a job fails at night, our tester see that the tables are not populated etc and send an email to everyone in the early morning so everyone knows that our jobs failed that night. so...

There is no possibility that someone is using kill command, however the node being overloaded might be a possibility although the dba/unix admin says it is not the case. our jobs run after midnight so the server shouldnot be busy at all. the jobs are not processing huge number of rows, the maximum n...

Thanks Craig, yes I searched the forum before I post this, the other posts about this didnot help me much, since the error log is vague so are the answers. I am using DataStage EE 7.5.1.A on AIX with 2 nodes, the target database is oracle 10G and the source is SQL sever and oracle. when I reset the ...

hi Everyone, I was wondering if you could help me to investigate the following problem I face in every 2-3 days with different jobs that runs nightly in production. I have no idea whether it is a bug in datastage EE or related with OS or database. there is no warning before but it says player someth...

thanks you, I can see the palette now. Thank god, Probably I was loking at when there is no job open, sorry for disturbing you for such a funny problem, I was worrying since yesterday because I am the only ETL person in this company and there is no one else I can ask, if I mess up the DataStage.

Hello Everybody, I have a weird problem in Designer, my palette has nothing in it, and I cannot customize it either, the palette customization is not working and when I try to load a new palette, there is no file under the palette folder? how can I get my palette or factory default palette back, whe...

I used a different delimiter, I think I solved the problem, the problem was as you guys said, some of the fields has new line character or the delimiter I was using before.

thanks a lot

I am still having ... Did you try use reject link when writing to seq file and also set appropriate reject properties.. Yes I did, there is no rejects when writing to the sequesntial file, ET jobs says 118 rows are written ( in the designer when the job runs), and I made sure this should be the cor...

ray.wurlod wrote:Are there any line terminator characters in your data? That is, is any of the "comments" multi-line in the source data?

I am not sure, there might be, because "comments" field is long defined as 4000 at lenght. if there is, how can I handle that?

From your data listing I would recommend trying with "|" as the final delimiter, unless you have 14 fields defined in the record layout. I am still having problems, my ET job is writing to a seq file and it shows it is written 118 rows, but when I read it in a load job, it reads 125 rows ...

Please verify that you have correctly specified the delimiter character as "|" and either 14 fields or 13 fields and a final delimiter of "|". that's right my staging job was not always putting delimiters. I am using end as a final delimiter is it ok? I will look at this now, bu...

If it is a read error then you should try to do a view data in the sequential file stage and see if the data is read properly in the stage indicated in the message. Anyways, can u post a few records of the file as it is, or check what Ray indicated ... the possibility of spaces et al being read int...