Omgili, forum search, forums search, search forums, discussion search,discussions search, search discussions, board search, boards search, search boards
  Advanced Search

Record level access and CLOBs

On Mon, 23 Jan 2012 11:43:53 +0100, "Franco Lombardo" <...@hotmail.com

Can I use Record Level Access to read data from files containing CLOBs and
BLOBs?
I only need to read "standard" fields from theese files, not CLOBs.

Thanks in advance.

Bye

Franco

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
http://www.francolombardo.net
Scala, Java, As400.....
http://twitter.com/f_lombardo
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing list
To post a message email: JAVA...@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA...@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.



On Mon, 23 Jan 2012 08:40:40 -0600, David Gibbs <...@midrange.com

You should be able to ... easiest way to find out is to give it a try.

david

--
IBM i on Power - For when you can't afford to be out of business
--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing list
To post a message email: JAVA...@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA...@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.

On Mon, 23 Jan 2012 16:44:18 +0100, "Franco Lombardo" <...@hotmail.com

"David Gibbs" wrote

As I tried and it didn't work, I was guessing if I was doing something wrong
or if it is impossible.

:-)

Thanks

Bye

Franco

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
http://www.francolombardo.net
Scala, Java, As400.....
http://twitter.com/f_lombardo
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing list
To post a message email: JAVA...@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA...@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.

On Mon, 23 Jan 2012 10:54:50 -0500, Charles Wilt <...@gmail.com

http://www.ibmsystemsmag.com/ibmi/developer/general/BLOBs,-CLOBs-and-RPG/?page= 2

"As mentioned previously, we'll only be able to access CLOB type
fields using SQL. As a matter of fact, if you even include an F-spec
in your program for a file containing a CLOB, your program may compile
(with warnings--but who looks at those?), but it will fail to open the
file at run time. You could natively access the rest of the data in
the file in RPG only by creating a logical file omitting the CLOB."

HTH,
Charles

On Mon, Jan 23, 2012 at 10:44 AM, Franco Lombardo
<...@hotmail.com--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing list
To post a message email: JAVA...@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA...@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.

On Mon, 23 Jan 2012 16:56:59 +0100, "Franco Lombardo" <...@hotmail.com

Thanks!

Bye

Franco

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
http://www.francolombardo.net
Scala, Java, As400.....
http://twitter.com/f_lombardo
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing list
To post a message email: JAVA...@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA...@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.

Discussion Title: Record level access and CLOBs
Title Keywords: Record  level  access  CLOBs