STORED PROCEDURE
Hi All i search to make procedure in strsql please can anybody help me and search code open text file from the procedure and put data on it Software/Hardware used: AS/400 sql400 DB2
Hi All i search to make procedure in strsql please can anybody help me and search code open text file from the procedure and put data on it Software/Hardware used: AS/400 sql400 DB2
10 pts.
SQL/400 Query to update one field in File1 with other field in File2
Hi All, I want to update one field(PCUSR6) in NBSPCNTR file for all records with MCUSR6 field from CASCNTRM file. I tried below combinations, but i couldn't do it. Can any one please help to update whole file with another file field. Please find below queries i tried: i have to update NBSPCNTR...
Hi All, I want to update one field(PCUSR6) in NBSPCNTR file for all records with MCUSR6 field from CASCNTRM file. I tried below combinations, but i couldn't do it. Can any one please help to update whole file with another file field. Please find below queries i tried: i have to update NBSPCNTR...
SQL/400 Call Level Interface
The option set thru the SQLSetConnectionAttr call persists until the next SQLSetConnectAttr call. If I need to set another option, how do I know that the effect of the previously set option is no longer required? Can I set connection attributes after I have connected to the database? Thank you...
The option set thru the SQLSetConnectionAttr call persists until the next SQLSetConnectAttr call. If I need to set another option, how do I know that the effect of the previously set option is no longer required? Can I set connection attributes after I have connected to the database? Thank you...
SQL/400 field editing
What is the best (easiest!!) way to add editing to fields in an SQL-created table?
What is the best (easiest!!) way to add editing to fields in an SQL-created table?
AS/400 SQL Update for matching records
I have a file of five fields containing a number of records. I want to update the value of field 5 on a second record where the second record matches the first record for the first three fields, but where field 4 is the opposite (negative) value of field 4 on the first record.EG: Record 1 12345678,...
I have a file of five fields containing a number of records. I want to update the value of field 5 on a second record where the second record matches the first record for the first three fields, but where field 4 is the opposite (negative) value of field 4 on the first record.EG: Record 1 12345678,...
SQL in an SQLRPGLE program
I want to use embedded SQL in an SQLRPGLE program to search a file for a field entered in a screen to select data using the LIKE operand. This is my code C/EXEC SQL C+ DECLARE C1 CURSOR FOR SELECT * FROM F0101JN WHERE ALADDZ = :SZIP C+...
I want to use embedded SQL in an SQLRPGLE program to search a file for a field entered in a screen to select data using the LIKE operand. This is my code C/EXEC SQL C+ DECLARE C1 CURSOR FOR SELECT * FROM F0101JN WHERE ALADDZ = :SZIP C+...
Duplicate object (PF) using SQL with same attributes
I want to create a duplicate object using SQL. I don't want to use CRTDUPOBJ and also do not want to compile my rpg's pgm because of new file level identifier. Please advice
I want to create a duplicate object using SQL. I don't want to use CRTDUPOBJ and also do not want to compile my rpg's pgm because of new file level identifier. Please advice
AS/400 Navigator
Hi , Can anyone tell me what is this problem when i try to click on the database tab in AS/400 navigator. Navigation: -> login to machine id->click on the machine-id->click on the database tab-> ERROR reported Function did not complete successfully. AS/400 Message ID: PWS0001 Cause...
Hi , Can anyone tell me what is this problem when i try to click on the database tab in AS/400 navigator. Navigation: -> login to machine id->click on the machine-id->click on the database tab-> ERROR reported Function did not complete successfully. AS/400 Message ID: PWS0001 Cause...
How to run SQL script with parameters in CL
I have to call an sql script with parameters from an existing cl program that runs daily (in batch). If I call it from the cl program, it is giving me this error "Pointer not set for referenced location referenced".
I have to call an sql script with parameters from an existing cl program that runs daily (in batch). If I call it from the cl program, it is giving me this error "Pointer not set for referenced location referenced".
CMPPFM, Space offset error.
Hello, I'm using the IBM CMPPFM utility for a file comparision process. I monitor for msg SPC5010 (file is too big ), if this occurs I submit an SQL EXCEPT to compare the files. This has been working fine until recently, now I'm getting the following error on one file, Space offset X'00FFF026'...
Hello, I'm using the IBM CMPPFM utility for a file comparision process. I monitor for msg SPC5010 (file is too big ), if this occurs I submit an SQL EXCEPT to compare the files. This has been working fine until recently, now I'm getting the following error on one file, Space offset X'00FFF026'...
SQL/400
Hi friends, I have on my System many Users with the userclass *SECOFR, How can I determine only one user to use the command STRSQL ?,
Hi friends, I have on my System many Users with the userclass *SECOFR, How can I determine only one user to use the command STRSQL ?,
Load table in AS/400 database using Talend
When i try to load a table in a AS400 database using talend 2.4.0, it given me an error like "There might be an error in SQL statement"
When i try to load a table in a AS400 database using talend 2.4.0, it given me an error like "There might be an error in SQL statement"
SQL View on 1 AS/400 using data from another AS/400
We have 2 AS400 machines connected with a 1g pipe. I need to create a SQL view on one of the machines using data that is in DDS physical files on the other machine. How can I accomplish this?
We have 2 AS400 machines connected with a 1g pipe. I need to create a SQL view on one of the machines using data that is in DDS physical files on the other machine. How can I accomplish this?
Ignoring fields in SQL Where Statement
Can fields in a where statment be ingnored. Such as Where name = :name and date = :date, but if I just pass in a name I'd like the where to select only on the name and ignore the date.
Can fields in a where statment be ingnored. Such as Where name = :name and date = :date, but if I just pass in a name I'd like the where to select only on the name and ignore the date.
Purpose of QSQJRN
Could someone tell me the purpose of the journal QSQJRN ? I don't journal any files on my system, so I don't know why this journal is active. It's now up to 200Mb. Thanks
Could someone tell me the purpose of the journal QSQJRN ? I don't journal any files on my system, so I don't know why this journal is active. It's now up to 200Mb. Thanks
Grouping the records in RPG
How to I group the records in the database based on one particular field?? When i try using a group by clause in the embedded SQL, it give me a 'SQL precompile failed' error. How do I handle this?? And i have to display the employee records grouped by their locations... how can this be done??
How to I group the records in the database based on one particular field?? When i try using a group by clause in the embedded SQL, it give me a 'SQL precompile failed' error. How do I handle this?? And i have to display the employee records grouped by their locations... how can this be done??
How to display the SQL query results on SDA screen?
I got an answer for how to embed the SQL statements in RPG program. Can you please help me with how to use these values in the program, or display them on the SDA screen??? Thank you. :)
I got an answer for how to embed the SQL statements in RPG program. Can you please help me with how to use these values in the program, or display them on the SDA screen??? Thank you. :)
THREADSAFE parameter on DSPCMD STRSQL
Can i get the help on this parameter whose values are *YES and *NO. The value is currently *NO, when should and how can i change it to *YES. Will this improve the performance of my SQL procedures?
Can i get the help on this parameter whose values are *YES and *NO. The value is currently *NO, when should and how can i change it to *YES. Will this improve the performance of my SQL procedures?
iSeries Access For Web - Run SQL Function
Hi Has anyone had the problem where iSeries Access For Web does not run some SQL features consistently? I have a customer that is using this to provide reports from the iSeries to his customers. Customers can log onto the iSeries from the web and get to run reports already created. The customer...
Hi Has anyone had the problem where iSeries Access For Web does not run some SQL features consistently? I have a customer that is using this to provide reports from the iSeries to his customers. Customers can log onto the iSeries from the web and get to run reports already created. The customer...
