DSXchange

As long as there is no data longer than 15 ( which is not possible anyway because your source table has 15,2) it should not give any warnings. but I am not sure as to why it gave warning in your original job

Good Afternoon folks, I have a few jobs that are summing up an amount field from a source table where the field is defined as decimal(15,2) .. Thanks - - JOhn What does it show in your job for that column as SQL type when you import the column definition? what database are you using in the source a...

Hi Waklook,

are your files one line file, or are you trying to read them in one row? maybe there is a problem with your EOL characters in your file

Hi, I have a small question, If we have, Source Database ---> Transformer ----> Sequential File a) Will this consume memory space - I guess yes b) Will this consume disk space (apart from sequential file) - like the sort stage uses disk space a) while running the job , yes b) yes, any job, regardle...

I have created a simple Parallel Job(This is the first time I have done it on this machine). It says "This jobtype is not currently runnable on this platform". Can somebody tell me what exactly is wrong with this . what version of DataStage are you using? it is probably for Unix OS only n...

No no , not trying to have fun with him, but really the answer to his question is , any number of processors ( except zero) is fine. I think ( it is just a guess), it is an interview question and what he is trying to ask is how many PROCESS will there be during the run time? Is it what you are tryin...

Did you check your uvconfig.odbc files and compare them?

bhaggu wrote:i have 4 nodes in my config file and 10 stages,so how many prosessors do i need?

more than zero

Another advise would be add a dummy column as a last column in your spreadsheet write a value in it and copy to all the other rows. when you read the file you can ignore this last column or you can drop it in the first transformer in your job. that will help also for a lot of other problems you migh...

chulett wrote:It's an environment variable, so would not say you couldn't "use" it - but you certainly couldn't for the purpose that it was intended.

So, it is quite normal that you are getting the error.

1. Generated the SQL statements (Insert) and ran them in SQL Plus. The SQL runs fine. With no discconection issue. 2. Replaced the DRS stage with an Oracle OCI stage , the job works fine. Now the question is why DRS stage is not working fine with this one? I never used DRS, and in your SQL, if you ...

tatireddi wrote:Hi Cetin:

Yes, i am doing on the DS Server edition.

Gurus,

Correct me if I am wrong but the APT_CONFIG_FILE and its usage is only for parallel edition not for server edition, if you don't have DS PX ( DSEE) installed you cannot use it.

and you are trying to do these for a server job in a DS server edition?

... Then show all process, I can find a few processes under my ID. then I try to logout them, but failed, they are still there. And If I click the process, and show locks by process. I found a few locks as well. then i try to release all. These locks are still there. .....thanks They are probably y...

DeepakCorning wrote:Thats what is bugging me

Let me try.. Also someone to,ld me that the generated SQL may be too long .. but thats also not the case..

Is it possible that your SQL or this particular job ending your connection with oracle, ?