Unless you write your own function there is no SQL function.
Sometimes ago I wrote a generic (external - RPGLE) User Defined Table
Function. This UDTF can read any CSV located within the IFS, splits the row
into separate columns and returns the column values
So I'm able to read any *.csv like a table as follows:
... any *.csv might be too much, because the number of columns returned is
restricted to 128 (I think with the most recent enhancements I could enhande
it to 1024 columns)
Select *
From Table(ReadCsv('/home/Hauser/myCsv.csv', ',')) x;;
The technique I used is described within the following article.
The Power of User Defined Table Functions
http://www.ibm.com/developerworks/ibmi/library/i-power-of-udtf/index.html
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von
rob@xxxxxxxxx
Gesendet: Friday, 07.8 2015 19:00
An: midrange-l@xxxxxxxxxxxx
Betreff: parsing a CSV column
Lets say I run a command the automatically populates a db2 column with
lparname1,1,status lparname2,2,status lparname3,3,status No danger of a
comma being imbedded other than as shown. IOW no risk of
"lpar,1,name",1,status.
I know I can parse this out with SQL with a bunch of LOCATE's and whatnot.
But, if there's some cool function that I'm missing I'd rather examine
that.
My workaround may be to pipe this out to a stream file instead of a DB2 file
and use CPYFRMIMPF. And if "I'm" looking at CPYFRMIMPF you know that's
desperation.
No CSVPARSE(fromstring, ColumnNbr) is there?
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail
to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
