Good morning,
I hope I am in the right section.
From my php I read a file from AS400 and the read data I have to write it to a new file in AS400.
When I go to do the insert (again with php) the accented characters (first name and last name) give me problems.
How can I...
74 results in 0.0034 seconds.
-
xrunner started a topic Can I use a qsys2.http_get function as the "line" value for qsys2.ifs_write?in SQLCan I use a qsys2.http_get function as the "line" value for qsys2.ifs_write?
I successfully use http_get() to retrieve documents from a web service of up to 4Mb and store them on the IFS using ifs_write(). Unfortunately, some of the documents requested are larger than what RPG allows (~16Mg if I remember).
I was wondering if I can skip over the need for a host variable... -
Convert iAccess SQL Script to a program
We have audit journaling turned on and recently encountered an issue with an error writing to the log. The message stopped all DB operations until it was answered. We purged our journal receivers using a SQL script provided by IBM. They suggested we run this periodically so I wanted to create a pro... -
Using Clob Fields in SQL
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... -
Problems with an INSERT with embedded SQL
Hello dear community,
I'm currently having trouble with an insert. I can't get an insert. In the debug I saw that the SQLCOD was set to -7008 (object-name NOT VALID FOR
OPERATION (reason code)). I've attached an image. Can someone tell me what I'm doing wrong? I create the file in QTEMP... -
A recursive query instead of a control-break scenario?
In a single table, I have a set of records (one table) for people with (potentially) multiple records per individual person. For each person, those multiple records have a date and severity code (possible 1 through 5 but not requirements on what values other than 1 through 5 and many don't have a 1).... -
Why REGEXP_COUNT returns a wrong value?
Hello all,
I'm puzzled why REGEXP_COUNT returns weird results, for example take this query:
PHP Code: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... -
Grouping a contiguous sequence?
Hi all,
So we all know well that poorly architected tables can lead to us having to do double backflips in SQL to try to get the data, right??
Does anyone have any tricks for grouping subsequent records that follow a contiguous sequence and then breaking to the next group when the...Last edited by CliffDowell; December 9, 2020, 04:10 PM. Reason: Edited to correct spacing in final result headers. -
SQL static View shows as a Logical File - recompile considerations
Hello,
I am a new IBMi programmer working in small shop with primarily legacy code. As part of our efforts to modernize, we want to take advantage of SQL static Views when creating reports that use sets of data. I created a SQL static View that uses fields from 4 different Physical Files.... -
SQL update to calculate totals on fly
I have an update that does a table rollover for monthly buckets along with a yearly bucket column, I am having an issue updating the yearly, I want to have the yearly bucket updated with the monthly i.e.
update table set col1 = current, col_2 = col_1, col_3 = col_2, ...col_12=col_11, yearly_col... -
Tracking Usage of a View
Hello everyone,
I've been trying recently to create some sort of event monitor (not sure if this is a correct solution) in DB2 to try to keep tracks of a view's usage (each time it i used it in a SELECT statement, for instance).
I've seen multiple solutions existing for T-SQL, but... -
CREATE FUNCTION (External) - Which Subprocedure?
Something I'm not clear on - In reviewing the syntax for CREATE FUNCTION (External), I know I can specify that the external procedure to be run is a subprocedure in a service program, and where to specify the service program.
However, I don't see where to specify the name of the actual... -
Getting information on an SQL SEQUENCE object
How can I get the current value of an SQL SEQUENCE object, WITHOUT incrementing it with NEXT VALUE FOR first?
Also, how can I get information about a SEQUENCE, such as min, max, increment value, etc? -
How to reclaim unused space from LOB/CLOB columns?
Hi.
I've been testing how the CLOB columns work (relative to disk space ).
I've tried erasing data from a couple of columns with CLOB data type (it seems VARCHAR and the other LOBs work in the same way).
I see there is no change about the size on disk occupied by the... -
Looking for Query/400 Alternative?
I'm currently in a very "traditional" and small IBM i/IT shop (6 person crew). While its been bitter-sweet to have some of our IT staff for 30+ years, they will soon be leaving the workforce for retirement, etc; thus my responsibilities will be more focused on the IBM i. We still rely heavily...