IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

InfoSphere OPTIM CSV ouput vs DSNTIUAL format


IBM Mainframe Forums -> IBM Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
jzhardy

Active User


Joined: 31 Oct 2006
Posts: 131
Location: brisbane

PostPosted: Tue Aug 08, 2023 7:29 am
Reply with quote

hi all,

I have a requirement to convert a large set of Optim extract files (each spanning over 200 tables) into DSNTIAUL format in readiness for a fast table load.

InfoSphere Optim does provide a utility to convert to external format, but only supports CSV delimited.

- are there any limitations around CSV output from Optim - eg, long varchar, XML types, binary representation etc?
- in terms of third party tools, is there anything out there that will transform CSV + catalogue data => DSNTIAUL - or (better) Optim Extract => DSNTIAUL?
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2022
Location: USA

PostPosted: Tue Aug 08, 2023 5:05 pm
Reply with quote

Try DFSORT/SYNCSORT
Back to top
View user's profile Send private message
jzhardy

Active User


Joined: 31 Oct 2006
Posts: 131
Location: brisbane

PostPosted: Wed Aug 09, 2023 4:16 am
Reply with quote

the problem is the Optim extract is a a proprietary format ..

the good news is that I found a way to generate to DSNTIAUL format within InfoSphere .. option 9;7 (archive;load). Don't know why I didn't see this before
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1742
Location: Tirupur, India

PostPosted: Wed Aug 09, 2023 5:03 pm
Reply with quote

Yes Optim already has a DSNTIAUL output format. I didnt suggest it earlier since you mentioned that you had already unloaded the 200 tables.

Anyways I am glad you figured out a solution
www.ibm.com/docs/en/iohpufdflu-and-w/6.1?topic=SSC6UE_6.1.0/inmuref_consynformato.htm

Code:
FORMAT DEL|IXF|DELIMITED|ASC|DSNTIAUL|XML|MIGRATION|JSON
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IBM Tools

 


Similar Topics
Topic Forum Replies
No new posts Populate last day of the Month in MMD... SYNCSORT 2
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Need to convert date format DFSORT/ICETOOL 20
No new posts user exit in IBM Infosphere Optim DB2 8
No new posts optim extract file - SAS DB2 2
Search our Forums:

Back to Top