Using Clob Fields in SQL

[tbrantley]

Has anyone tried using a clob field inside of SQL?

I'm moving the data from the YAJL copyBufStr function into a clob variable.

Once I try to use the clob variable inside the SQL statement I get the error below.

Length in varying-length, LOB, or XML host variable...

[Alabama Mothman]

Hello, Im trying to move a java string to an alphanumeric System I subfile field. The compiler isnt allowing it. How do I convert java string to String to System i alphanumeric. I could noit find anything about it on google.


rsmd = jdbc_GetMetaData(rs);
colcnt = jdbc_GetColCount(rsmd);...

[Alabama Mothman]

Trying to use RPGILE to obtain a DB2 metadata resultset. Does someone know of a DB2 RPGILE getMetaData example. Do I first have to get a "select" result set before using getMetaData... Trying to get columns and data attributes. Similar to DBU.

Or can it be built without a beforehand...

[jemrugIBMi]

Hi All,

I am researching Kerberos in the IBM midrange environment. I am a developer.

I have client server desktop application. Front end java(using JT400 api) and backend Rpgle(PCML). So the client is using a mixture JDBC Sql and backend rpgle program calls.

My...

[Carpiem]

Hello all,

I'm puzzled why REGEXP_COUNT returns weird results, for example take this query:

select regexp_count('1','[A-Z]')
from SYSIBM.SYSDUMMY1 

Regular expression [A-Z] means it accepts a letter from A to Z. But 1 is no letter, and the result of...

[rudra]

Good Morning/ Evening All,

Need your expert advice.

We have a requirement wherein we have to migrate the data from Oracle 11i to DB2 on IBM i (on V7R2). Need your guidance for the below:

1. Is there any IBM proprietary tool which can help us in the migration? Or...

[vijayrmca]

All,

I am having one DB2 query

SELECT year(current date)*10000 +
month(current date)*100 +
day(current date-1 days),count(*) FROM mstfile.

Above query gives me the result as 20200108 ,100 as output...

[CaptainRon]

All, this works just fine
STRPCCMD PCCMD(&URL) PAUSE(*NO)

Except when you call it from the 5250 screen and it opens up a browser the 5250 screen is black and waiting on you to click it before it will display the screen back to where you called the CL from.
Anyone else...

[VigneshMohan]

The system defined default value for a date column in DB2/iSeries is always "current date". How can we change that to '01/01/0001' (*LOVAL) ?

When I insert a record via RPGLE, the date fields always default to *LOVAL.
Whereas, when I insert a record using SQL (or an ETL...

[CaptainRon]

So I have been doing Journals forever and using them to see what has happened to a file etc. We have a production system that has journaling turned on. What I want to do is extract specific files ( I already know how to do all that ) to the test system. I can do this by extracting the production...

[CaptainRon]

b/c of some weird unknown reason. We have an HP printer that when it runs out of paper it needs varied off and back on. This user does not have authority to the device. How can I in a CL program allow them to do this? I have tried GRTACCAUT but that does not work. Gives me an error saying they...

[StevenDyke]

The following sql statement runs from an external IDE but gives me an error on line 15 position 14 When ran in the iSeries environment:
Error: Position 14 Token SUM was not valid. Valid tokens: ) ,.

0011.00 UPDATE OIPAYFILES/EMPLOYEE SET PRURN2 = PRURN1 - (PRURN5 + (SELECT
0012.00...

[paolinosal]

HI all,

I was trying the systools function base64 encode and decode but I have a little problem with the decode...

here's a test case:

Create Table Testbase64(Rowid Int Not Null Generated Always As Identity (Start With 1, Increment By 1, No
Cache), Fieldutf8

...

[dlanz12345]

I have a query which takes less than a second to execute from iNavigator. When I run the same query from a php script and then loop through it using:

$numRows = 0;
while ($row = db2_fetch_assoc($stmt))
{
//Do stuff
$numRows++;
}
echo

...