74 results in 0.0025 seconds.
-
DataStructure SORT on two different fields.....
So I have a Data structure array. I can sort on one field using the SORTA command with %subarr. Can I add another field WITHOUT combining the two fields together in a one field sort? To basically sorting on two fields or three etc..... Again without combining into one field. If I can in SQL do you... -
Override System Default Value - Date Column
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... -
Dspfd *accpth
Hi all,
I wasn't sure where to post this so here goes. If it belongs somewhere else please let me know.
I'm going crazy over a problem I cannot resolve, I've wrestled this for days and all my research hasn't turned up anything.
I am getting a "decimal data... -
XMLATTRIBUTE Function New Line Character
I am trying to create an XML using the SQL XML functions. One of the things that I need to do is add newlines to an attribute value. The special character sequence for new line is " ". When I run that through the XMLATTRIBUTE function it comes out as 
 because the &... -
Stored procedure on AS400 - how works cursor and update statement
Hi guys, I have a question, I have a stored procedure on AS400 and I see that I can call like this: call library.prcocedure_name(parameters), the object on AS400 is *pgm type. I never worked since now with stored procedure and for this reason I don't have very large knowledge.
I understand that... -
SET based SQL Tip - Splitting rows using common table expressions
This document contains two real world examples which show how to use SET based SQL and common table expressions, to split input rows, into multiple output rows, unconditionally, or conditionally.
There are many reasons to shift many types of work to SET based SQL, but improved performance... -
Dynamic SQL - conditional build vs embedded conditions
I'm working on an SQL program that will read data from a file into a subfile. There are lots of optional conditions that the user can input.
I'm looking at two approaches.
The obvious way is dynamically including only the relevant conditions when I build the SQL string,... -
Dropping a schema without generating inquiry message CPA7025
I'm writing either a CLLE program or an SQL script to build a schema full of tables, programs, and service programs, and I'd like it to be fully automated.
My issue is that in the beginning of the CL, when dropping the schema if it already exists, an inquiry message, CPA7025, is generated... -
Michael Jones started a topic Free e-book: Converting RPG to Set Based SQL (Part 1: Input Operations)in RPG/RPGLEFree e-book: Converting RPG to Set Based SQL (Part 1: Input Operations)
Below is a link to download a free e-book to help current, or former, RPG programmers learn SET based SQL. There are significant benefits when using SQL for I/O, but the benefits increase dramatically when you use SET based SQL (versus one row at a time processing). This is a learn by example book with... -
Slightly Complicated Statement works one place not another
So, I have the following SQL statement.
...PHP Code:EXEC SQL
INSERT INTO ENTPART (IRS#,ITEM#,OKAYTOUSE,HTS#1,HTS#2,HTS#3,
DESC,UNT$,WGTLN,PCLS,PRDCD,COMM1,COMM2,COMM3,COMM4,COMM5,
COMM6) SELECT DISTINCT (SELECT IRS#CS FROM CUSTHEAD
where CUS#CS = $S_CUSTF
-
Embedded SQL Access Paths and For Update Of
I've been an RPGLE programmer for a while, but the company I work for who taught me RPG does not use embedded SQL. I am only just starting to teach myself.
According to this article: http://www.itjungle.com/fhg/fhg010709-story02.html
If you update a table through a cursor, SQL... -
Retrieving the current record count of an executing SQL operation
If an RPG program executes an SQL statement such as "DELETE FROM table1", is there any way to retrieve the number of records that it has currently deleted similar to how the interactive SQL session on the iSeries manages it?
I might be deleting from large files and it would... -
View in COBOL in place of physical file
Hi guys,
I have a question if you can help me please, I have to use a view created with SQL in place of the physical file, I created the view with sql and I don't have dds for this:
create view library.file_view
as select*from library.pysical_file
where some conditions... -
An Idea For Processing Trigger Files
I haven't used trigger files before, but I wondered what people think of the method below, instead of using data queues.
I have about 20 files that I need to synchronize with their equivalents in a MySQL database. I already have a PHP script that reads all the data and creates each MySQL... -
Pound Sign (£) Does Not Convert Correctly DB2 SQL -> MySQL
Not sure whether to post this under PHP or SQL, but thought with more activity this would be better.
I have a PHP script that reads from a DB2 table and inserts the content to a MySQL table (it runs on the iSeries).
All works fine, except that in MySQL the "£" sign is...
