[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: writing CLOB to IFS file - CCSID issue
Kara - can you map a network drive to the IFS and open it from web
browser? Something like this (where Z is the mapped drive letter):
[1]file:///Z:/myStuff/Reports/Res_by_Customer.html
Gene Cobb
Technical Consultant - DB2 for i and DB2 Web Query
DB2 for i Development Team
cobbg@xxxxxxxxxx
www-03.ibm.com/systems/i/software/db2/
Inactive hide details for Kara Burkhalter ---04/21/2009 07:20:25
AM---My RPG/SQL code is producing the file on the IFS. If I d Kara
Burkhalter ---04/21/2009 07:20:25 AM---My RPG/SQL code is producing
the file on the IFS. If I do wrklnk to that file I can view the html
From:
Kara Burkhalter <Kara.Burkhalter@xxxxxxxxxxxxxxxxxxxxx>
To:
HTTPAPI and FTPAPI Projects <ftpapi@xxxxxxxxxxxxxxxxxxxxxx>
Date:
04/21/2009 07:20 AM
Subject:
Re: writing CLOB to IFS file - CCSID issue
______________________________________________________________________
My RPG/SQL code is producing the file on the IFS. If I do wrklnk to
that
file I can view the html source code that was in the clob. If I try
to
open the file from the IFS from my pc thru Ops Navigator I don't get
the
correct data and it appears to be CCSID problem.
Thanks
Kara
P Please consider the environment before printing this e-mail
Scott Klement <sk@xxxxxxxxxxxxxxxx>
Sent by: ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx
04/20/2009 08:00 PM
Please respond to
HTTPAPI and FTPAPI Projects <ftpapi@xxxxxxxxxxxxxxxxxxxxxx>
To
HTTPAPI and FTPAPI Projects <ftpapi@xxxxxxxxxxxxxxxxxxxxxx>
cc
Subject
Re: writing CLOB to IFS file - CCSID issue
Hi Kara,
I don't understand how the data is getting to a PC? Are you running
RPG code (like the sample you provided) and then viewing that file
from
a PC? Or are you using ODBC or similar from a PC program?
For that matter, how are you viewing the data on i? Are you
outputting
to a file (as shown) and then reading that file somehow from RPG? If
so, are you reading it in binary mode, or...?
Kara Burkhalter wrote:
> Hi,
> I am using HTTPAPI to create a temporary filename in the IFS to
write
> a CLOB (which is just html code) to it so it can be opened from
the
> green screen to view. I have successfully created the ifs and
wrote
> the clob to and can view the html code doing wrklnk...., but when
I
> open on the PC I get a bunch of weird characters. I know this is
a
> CCSID issue (the Clob is defined as 37 and the file is created
with
> CCSID 37) but I'm not sure what I need to do to get it to be
readable
> when opened on PC as a HTML doc.
> ***************************************************
> * Ask HTTPAPI for a temporary filename in the IFS.
> ****************************************************
> C eval IfsFile = http_tempfile()
> C eval ifsFile = %trim(ifsFile) +
'.html'
> C eval Doc = *ALLx'00'
> C eval Doc_FO = SQFOVR
> C eval Doc_Name = IfsFile
> c eval Doc_NL = %len(IfsFile)
> C/EXEC SQL Select text
> C+ Into :Doc
> C+ From conrslt2
> C+ Where conseq = :conseq
> C+ with NC
> C/END-EXEC
>
>
> Thanks,
> Kara
>
> P Please consider the environment before printing this e-mail
>
>
>
>
> This message may contain confidential or proprietary information
and
> is intended only for the person(s) to whom it is addressed. Any
use,
> distribution, copying or disclosure of confidential information
by
any
> other person is strictly prohibited. If you have received this
message
> in error, please notify the e-mail sender immediately, and delete
the
> original message without making a copy. For information on the UW
> Foundation's privacy policy, please visit:
>
> [1]UW Foundation Privacy Policy
>
> References
>
> 1.
[2]http://www.uwfoundation.wisc.edu/home/privacypolicy/privacypolicy.a
spx#email
>
>
>
>
----------------------------------------------------------------------
--
>
>
----------------------------------------------------------------------
-
> This is the FTPAPI mailing list. To unsubscribe, please go to:
> [3]http://www.scottklement.com/mailman/listinfo/ftpapi
>
----------------------------------------------------------------------
-
----------------------------------------------------------------------
-
This is the FTPAPI mailing list. To unsubscribe, please go to:
[4]http://www.scottklement.com/mailman/listinfo/ftpapi
----------------------------------------------------------------------
-
This message may contain confidential or proprietary information and
is
intended only for the person(s) to whom it is addressed. Any use,
distribution, copying or disclosure of confidential information by any
other person is strictly prohibited. If you have received this message
in
error, please notify the e-mail sender immediately, and delete the
original message without making a copy. For information on the UW
Foundation's privacy policy, please visit:
UW Foundation Privacy Policy
----------------------------------------------------------------------
-
This is the FTPAPI mailing list. To unsubscribe, please go to:
[5]http://www.scottklement.com/mailman/listinfo/ftpapi
----------------------------------------------------------------------
-
References
1. file://localhost/Z:/myStuff/Reports/Res_by_Customer.html
2. http://www.uwfoundation.wisc.edu/home/privacypolicy/privacypolicy.aspx#email
3. http://www.scottklement.com/mailman/listinfo/ftpapi
4. http://www.scottklement.com/mailman/listinfo/ftpapi
5. http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------
This is the FTPAPI mailing list. To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------