DSXchange

Hi All I needed to delete data from 4 tables..i am trying to achieve this in a single job. i have a job design which is as follows Oracle Stage----->Dummy File Firstly i don't think i can rite one single SQL to delete data from all the four tables at a go with where clause.... This leaves me with wr...

Kumar,

Nope it gives the same error Thanks
Pavan

Hi aslam and chulett
i am using dir /a-d | find ".txt" in my script....
The error is a bit wierd like "CANN'T ACCESS .TXT"...
Never the less the dir /b *.zip is working...
Thanks a lot guys

Thanks
Pavan

I am doing a CD before i fire the Dir command and i am seeing the files i want to see when i do the dir /b... And yes the '.' can be used as a delimiter cool :idea: My dir /b is giving this output Count1.txt Count2.txt Temp.zip FTPScript_New.bat Temp1.zip In this i want only Temp.zip and Temp1.zip t...

Hi All I am trying to find a set of files with extension .zip from a file folder. I am working around a DOS Script for this which is doing a lot of other functionality.. For some wierd reason when i code in my DOS Script the following Syntax dir /a-d|find ".zip" It is giving me an error sa...

Hi ray and chulett
Thanks for all the help

Hi ray Sorry if the question was not properly asked...I don't intend to delete the whole table but delete it based on a some criterion in the where clause... And can you also please re-confirm me that my understanding that SQL commands through basic will be revoked after 30 days without proper licen...

Hi All What is the best way of firing a delete command on the database. One of the threads in the forum sugested that any operations on the database from Datastage Basic will stop working after 30 days as there are separate licences need to be brought for doing that from Data direct. I guess the oth...

Thanks for the Reply gateley.... The time stamp applied in the tables is the current system date and time stamp when the basic job control runs. With the said solution i guess i need to hold these failed time stamps somewhere to delete the data at a later point of time as i am not doing the load and...

Hi Guru Thanks a lot for the Info Gateleys Thanks a lot and i like the idea. it is cool and clean. it is easy to implement as well. It would be really helpful if you can just clarify me on the last part. Let the FailLink loop back to the start of SubSeq1, so that it fires the jobs again (deleting th...

It is an Oracle database. Thanks Guru I will try what you suggested. In between why is the design wrong or unstable if we have four independent links running in a job. I don't get the logic why it shouldn't be done. Even if we have a sequencer to run these four jobs. The four Job activity stages wil...

Hi DSguru If i understand it right you want my job design to look like follows one Job with the following design and with the transcation size and warning logic. ----------------------- File1----->Table1 File2----->Table2 File3----->Table3 File4----->Table4 ----------------------- Right now i have t...

Hi All What is the best way of deleting partially loaded data? My scenario goes like this i have four jobs which i am calling in a Basic control job. Each of the Jobs takes a file and loads in to a table. If there is a failure on any one of the Jobs i want to delete the data which is loaded in all t...

Hi Arnd and Chulett
Thanks a lot for all the help...

Thanks
Pavan

Hi Looks like there seems to be contradicting answers here. As for ArndW the Job aborts as soon as it hits a bad record. Sorry if i am understanding it wrong but Chulett seems to say that the Job will run logging an warning for every bad record. And the Job will only abort only if the job warnings l...