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

optim extract file - SAS


IBM Mainframe Forums -> DB2
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: Fri May 05, 2023 6:27 pm
Reply with quote

does anyone know if there is a utility to enable SAS to load tables direct from Optim extract files (z/OS platform) ?

it's a fairly niche requirement. Normally I would create a db2 connection and load the data directly, but I have some data available only as Optim extract files. I can code around this of course, but it's a bit of work and I don't want to re-invent the wheel if someone has worked out a solution.
Back to top
View user's profile Send private message
vasanthz

Global Moderator


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

PostPosted: Fri May 05, 2023 6:48 pm
Reply with quote

I dont know of any way to read the Optim unload files in SAS? Optim does data masking if you enable it, so not sure how you would be handling it in SAS.

I assume Optim must be using some sort of proprietary file format for storing the archives?
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania

PostPosted: Sat May 06, 2023 12:40 am
Reply with quote

The only way I know to 'read' an Optim Extract dataset is with Optim itself. It is in a propriety format. You can Browse with the Optim Product, or Insert as well.

Optim does have an option to create a DB2 Load dataset from the Optim Extract. You can use the DB2 Load Output of that process as input into your SAS program.

Use Option 7.3 from Optim Main Menu.
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 -> DB2

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
Search our Forums:

Back to Top