TechTip: Accessing Packed Data in "Flat" Files (1 viewing) (1) Guest
Favoured: 0
|
|
|
TOPIC: TechTip: Accessing Packed Data in "Flat" Files
|
|
|
|
TechTip: Accessing Packed Data in "Flat" Files 4 Years, 2 Months ago
|
|
|
And... <p>if you put your complicated SQL statements, with all the substrings in a User Defined Table Function (UDTF), you can get access from any SQL interface (interactive, embedded SQL, ODBC, JDBC etd) with ease! It is like to use any other table. <p>I think the UDTFs are a real great innovation in release V5R2M0. <p>Birgitta
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
|
TechTip: Accessing Packed Data in "Flat" Files 4 Years, 2 Months ago
|
Karma: 1
|
|
This is a discussion about <B>TechTip: Accessing Packed Data in "Flat" Files</b>.<p align='center'><a href=http://www.mcpressonline.com/mc?
This e-mail address is being protected from spam bots, you need JavaScript enabled to view it
@.6b16d2ce>Click here for the article</a>.</p>
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
|
TechTip: Accessing Packed Data in "Flat" Files 4 Years, 2 Months ago
|
Karma: 0
|
|
Birgitta, <p>That is a great idea. I just wanted to illustrate the concept, but a table function that did the whole job one time, is a great idea. Though I think a function that performs the specific job of unpacking the data is a good idea too rather than repeating that bit of code over and over again. <p>If someone doesn't beat me to it, I'll post a reply or a tech tip that includes those ideas. <p>Thanks for the suggestion! <p>Kevin
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
|
|
