DSXchange

All,
Thanks a lot for the advice. the column level warning rule is appropriate for my problem.

Thats true i pasted only one as lately i was trying only one to see that is is a problem with multiple SQLs or problem is with All SQLs.

I'll try this solution and will let you know if it works.

Thanks again for all the help and support.

Any Idea Whats Trace mode and in Log its showing tracemode=0 and if i want to set it how can i set it.

In the Log it only Says

"Update_BeforeSQL..Teradata_API_1: Executing BeforeSQL"

No Detailed Description.

Ross Here is the Before TAB Query UPDATE DD_STG_COMPGSM.CDRs_Ericsson_MSC SET CDR_File_Seq_No = '1' WHERE EMRFR_ORIG_National_No = '555244391'; Here is the Generated Query SELECT CDR_Record_Type,CDR_Creation_Date,CDR_Creation_Time,CDR_File_Seq_No,Record_Type,EMRFR_ORIG_National_No,EMRTO_Termnat_No,E...

Ross, I am in Saudi Arabia :) and its working day over here Week end is THU and FRI :) so i am on work though here today is a National Holiday but i have to meet a deadline so i am working :( I am checking the LOG and i have unchecked the SQL error but still no error in LOG. So i am now confused tha...

Ross, Thanks for the reply the SQL is perfect as i have tested in Client Software and if my stage sends out put to other stage it does not work but on the other hand it receives data the SQL in before stage works. and can yo please tell me from where i can invoke the job paramater page as if i press...

Hi, I want to know the difference between Active Stage and Passive Stage. Secondly every job makes some intermediate files is there ay wayt o remove those files automatically. e.g. when i go and check the project folder i see some files with the names of the links names. how can i remove those files...

Hi, I am inserting and then deleting the records from the base table which contain missing key columns into another table in the Teradata API before selecting the data from that table but apparently the SQL in BEFORE TAB does not seem to work. When i go back and check the base table it contains the ...

Thanks for the tip i would like to die outside Designer

Hi, I have a folder where i have multiple files of same format ('|' delimited columns). i am using folder stage to read all the files and then combine those files into 1 file, there is a possibility that files may contain error rows like if the correct row is delimited with 5 pipes('|') and incorrec...

HI, I have a job which i am running in my development ENV. everytime the job fails i have to recompile it again to RUN. i want to ask is it necessary to reompile it as it is a problem to compile the job all the time. Can someone please throw some light on recompiling philosophy of DS as i undertand ...

Andrew,
Thanks a lot for sharing the experience as we are running into the same kind of problems and this will help us a lot as we have the same HW/SW config except that we are running DS on Windows 2000 Server.

Any HW/Infrastructure Recommendations you would like to give?

Sorry i mean if there NO isuues then can you please share your best practices.

Andrew,
If there are isseues can you share you best practices as it will help us a lot.