|
View previous topic :: View next topic
|
| Author |
Message |
jzhardy
Active User
Joined: 31 Oct 2006
Posts: 139
Location: brisbane
|
|
|
|
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 |
|
 |
vasanthz
Global Moderator
Joined: 28 Aug 2007
Posts: 1744
Location: Tirupur, India
|
|
|
|
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 |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania
|
|
|
|
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 |
|
|
|
|
