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 Loading data to table gives wrong for... Raghu navaikulam DB2 18 Thu Jul 13, 2017 2:11 pm
No new posts Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am


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