Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Deleting records from teradata table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
murugan_mf

Active User


Joined: 31 Jan 2008
Posts: 148
Location: Chennai, India

PostPosted: Fri Oct 24, 2008 12:03 pm    Post subject: Deleting records from teradata table
Reply with quote

Hi,

I have a daily job which needs to delete records from teradata table before loading the table everyday.

Through MLOAD we can load data to teradata table.Is it possible to wipe out the records in the table before loading with new records.

Thanx in advance for ur reply.

Thanks!
Murugan.l
Back to top
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Oct 24, 2008 12:42 pm    Post subject:
Reply with quote

Hi,

I'm not a Dataware House guy, however this is what I got after surfing the net a little:

Quote:
We just drop and recreate the staging table every time. We keep a pristine version of the table with zero rows called xxx_staging_tmpl(template). So after the table is dropped we just do a CTAS from template. Just make sure that the staging table you create is multiset and the same primary key as the template table.

Quote:
In informatica, you can create multiple Mload connections like
Insert Mload
Update Mload
Delete Mload
Upsert Mload

If you wanna delete records from table, use Delete Mload, Truncate option will be disabled, if you use external loaders.


PS. Today work-load is lil less.. icon_wink.gif
Back to top
View user's profile Send private message
murugan_mf

Active User


Joined: 31 Jan 2008
Posts: 148
Location: Chennai, India

PostPosted: Fri Oct 24, 2008 1:42 pm    Post subject:
Reply with quote

Thanx anuj.But i dont know Delete Mload is possible in teradata.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Oct 24, 2008 1:46 pm    Post subject:
Reply with quote

Hi,

Search on "mload scripts + delete" in Google.
Back to top
View user's profile Send private message
murugan_mf

Active User


Joined: 31 Jan 2008
Posts: 148
Location: Chennai, India

PostPosted: Fri Oct 24, 2008 1:46 pm    Post subject:
Reply with quote

Anuj i checked in the manual and i could find the syntax for Delete MLOAD.Thanks again!
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Oct 24, 2008 2:18 pm    Post subject:
Reply with quote

Great, Hopefully syntax will be implemented successfully.

Have a Great weekend & Happy Diwali... icon_smile.gif

-Ad
Back to top
View user's profile Send private message
murugan_mf

Active User


Joined: 31 Jan 2008
Posts: 148
Location: Chennai, India

PostPosted: Fri Oct 24, 2008 2:27 pm    Post subject:
Reply with quote

Happy Diwali
Back to top
View user's profile Send private message
dharmendra_kp

New User


Joined: 10 Mar 2005
Posts: 33
Location: Lewiston

PostPosted: Fri Oct 24, 2008 4:56 pm    Post subject:
Reply with quote

I gues load process transfers data from file (PS) to table. So in order to delete the table containt can we load an empty file? That is how we delete data DB2 tables.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to split the records using the am... vnktrrd DFSORT/ICETOOL 24 Fri Oct 28, 2016 7:33 pm
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us