Cross reference tool
Hello, I’m currently working in an AS400 native RPG-environment, not ILE, and I want to create a cross reference for a part of the system(about 10 libraries). I’d like to create this by myself with the common commands on our system, I can do this thru DSPPGMREF and DSPBDR, DSPFD, DSPFFD, etc… But the problem [...]
Answer Question
| October 20, 2009 8:25 AM
RPG, SQL
Hello, I’m currently working in an AS400 native RPG-environment, not ILE, and I want to create a cross reference for a part of the system(about 10 libraries). I’d like to create this by myself with the common commands on our system, I can do this thru DSPPGMREF and DSPBDR, DSPFD, DSPFFD, etc… But the problem [...]
Answer Question
| October 20, 2009 8:25 AM
RPG, SQL
Multiple result sets returned from embedded SQL in RPG
I am trying to follow various examples (examples from Iseries Network and IBM manuals) for declaring a cursor and fetching records. I have no problem with simple statements. I am having trouble converting a statement containing a subquery. The more I look at different examples, the more trouble I am having. Can you help? This [...]
Answer Question
| January 31, 2005 5:41 PM
RPG, SQL
I am trying to follow various examples (examples from Iseries Network and IBM manuals) for declaring a cursor and fetching records. I have no problem with simple statements. I am having trouble converting a statement containing a subquery. The more I look at different examples, the more trouble I am having. Can you help? This [...]
Answer Question
| January 31, 2005 5:41 PM
RPG, SQL
How to purge records from the database?
I am a newbie to database programming and have been given this project where data older than 7 days need to be removed from multiple tables that the application uses. I am thinking about creating a stored procedure to do that and schedule a job that will run this stored procedure everyday. Not sure if [...]
Answer Question
| December 21, 2004 4:42 PM
Database, DB2, Implementation, Oracle, SQL, SQL Server, T-SQL, Tech support
I am a newbie to database programming and have been given this project where data older than 7 days need to be removed from multiple tables that the application uses. I am thinking about creating a stored procedure to do that and schedule a job that will run this stored procedure everyday. Not sure if [...]
Answer Question
| December 21, 2004 4:42 PM
Database, DB2, Implementation, Oracle, SQL, SQL Server, T-SQL, Tech support
Calling a Function which uses ado command object in ASP
Hi… I am calling a function or sub if u may call it from within the same page. it works fine until i execute a ado command object. as soon as i put the execute statement in the page, all activites stop and the page doesnt execute any further from the line calling that function. [...]
Answer Question
| December 15, 2004 9:10 AM
ASP, SQL, T-SQL
Hi… I am calling a function or sub if u may call it from within the same page. it works fine until i execute a ado command object. as soon as i put the execute statement in the page, all activites stop and the page doesnt execute any further from the line calling that function. [...]
Answer Question
| December 15, 2004 9:10 AM
ASP, SQL, T-SQL
ACCESS+SQL+CASE
What is the syntax of the CASE instruction In MS Access sql SELECT statement? May I see some examples? thanks bjozsi
Answer Question
| December 14, 2004 8:17 AM
SQL
What is the syntax of the CASE instruction In MS Access sql SELECT statement? May I see some examples? thanks bjozsi
Answer Question
| December 14, 2004 8:17 AM
SQL
Session ID of User
I want to write a select statement in a database table trigger to see who is deleting a record (User, PC name, program). V$session provides the info but I do not know how to identify the session that is deleting. Please help. Oracle 8.0.5 on NT Server
Answer Question
| February 14, 2005 7:20 AM
SQL
I want to write a select statement in a database table trigger to see who is deleting a record (User, PC name, program). V$session provides the info but I do not know how to identify the session that is deleting. Please help. Oracle 8.0.5 on NT Server
Answer Question
| February 14, 2005 7:20 AM
SQL
DB2/400 : SQL update error!! help me ^^
DEAR Kent Milligan Thank you for reviewing my question. I am using DB2/400 and want to update ‘VALUE’ column of TBL1 WITH ‘PRICE’ of TBL2. Here’s description of two tables. TBL1 TBL2 ———— ————- ID | VALUE ID | PRICE ———— ————- 1 | 10 1 | 100 2 | 20 2 | 200 3 [...]
Answer Question
| December 3, 2004 6:33 PM
Development, SQL
DEAR Kent Milligan Thank you for reviewing my question. I am using DB2/400 and want to update ‘VALUE’ column of TBL1 WITH ‘PRICE’ of TBL2. Here’s description of two tables. TBL1 TBL2 ———— ————- ID | VALUE ID | PRICE ———— ————- 1 | 10 1 | 100 2 | 20 2 | 200 3 [...]
Answer Question
| December 3, 2004 6:33 PM
Development, SQL
Using keyword IN in Dynamic SQL WHERE clause
In an RPGLE program I am using embedded SQL. I would like a Where clause that says: WHERE BankCode in (:BankList) and I want BankList to be a dynamic list of banks selected by the user. BankCode is defined as 4,0 decimal and BankList is defined as Character since it may have several banks (1000, [...]
Answer Question
| December 2, 2004 10:39 AM
RPG, SQL
In an RPGLE program I am using embedded SQL. I would like a Where clause that says: WHERE BankCode in (:BankList) and I want BankList to be a dynamic list of banks selected by the user. BankCode is defined as 4,0 decimal and BankList is defined as Character since it may have several banks (1000, [...]
Answer Question
| December 2, 2004 10:39 AM
RPG, SQL
ORA-03113 error while compiling Oracle packages
Hi All Recently we migrated our PLSQL code from Oracle 8.1.7.0 to 9.2.0.4. While compiling our packages in 9i, we are getting the ORA-03113: end-of-file on communication channel error. This happens only when we compile two particular packages. And then when we connect again immediately, and recompile the same package, it gets compiled. This is [...]
Answer Question
| November 26, 2004 5:11 AM
Oracle, Oracle 8i, Oracle 9i, SQL, Standard Edition
Hi All Recently we migrated our PLSQL code from Oracle 8.1.7.0 to 9.2.0.4. While compiling our packages in 9i, we are getting the ORA-03113: end-of-file on communication channel error. This happens only when we compile two particular packages. And then when we connect again immediately, and recompile the same package, it gets compiled. This is [...]
Answer Question
| November 26, 2004 5:11 AM
Oracle, Oracle 8i, Oracle 9i, SQL, Standard Edition
Performance Tuninig of a Select Query.
Dear All I am facing a performance tuning problem on the following query: select a.col1 as OID from table2 b,table1 a where a.col1 = b.col1 and b.col2 = 1568673860 and a.col2 in (select col1 from table3 where col2 in (‘SUFFIX_CODE’,'CONFIG_SEQ’,'SOUCHI_KBN’,'GENKA_CODE’,'MFG_STATUS’,'SALES_NO’,'PRODUCT_TYPE’,'OWNER_NAME’,'UPDATE’,'OWNER_GROUP_NAME’,'BU_CODE’,'DEVELOPMENT_CODE’,'PRODUCT_NO’)) and a.col3 like DECODE(a.col2,-922394134,’INN%’); table1 has 20 million records table2 has 1 million records table [...]
Answer Question
| November 19, 2004 8:50 PM
Development, Oracle, SQL
Dear All I am facing a performance tuning problem on the following query: select a.col1 as OID from table2 b,table1 a where a.col1 = b.col1 and b.col2 = 1568673860 and a.col2 in (select col1 from table3 where col2 in (‘SUFFIX_CODE’,'CONFIG_SEQ’,'SOUCHI_KBN’,'GENKA_CODE’,'MFG_STATUS’,'SALES_NO’,'PRODUCT_TYPE’,'OWNER_NAME’,'UPDATE’,'OWNER_GROUP_NAME’,'BU_CODE’,'DEVELOPMENT_CODE’,'PRODUCT_NO’)) and a.col3 like DECODE(a.col2,-922394134,’INN%’); table1 has 20 million records table2 has 1 million records table [...]
Answer Question
| November 19, 2004 8:50 PM
Development, Oracle, SQL
PL SQL Record in Java-2
Dear All I have a Stored Package written as follows: CREATE OR REPLACE PACKAGE firstPackage IS –Type definition TYPE sampleType IS RECORD ( name VARCHAR2(128), interface VARCHAR2(128), tablespc VARCHAR2(128) ); TYPE c_mx1_type IS REF CURSOR; –procedure definition PROCEDURE iwelcome( iNum in NUMBER, iOutput out NUMBER, st out sampleType ); PROCEDURE uwelcome; END firstPackage; / create [...]
Answer Question
| November 9, 2004 10:41 PM
J2EE, Java, SQL
Dear All I have a Stored Package written as follows: CREATE OR REPLACE PACKAGE firstPackage IS –Type definition TYPE sampleType IS RECORD ( name VARCHAR2(128), interface VARCHAR2(128), tablespc VARCHAR2(128) ); TYPE c_mx1_type IS REF CURSOR; –procedure definition PROCEDURE iwelcome( iNum in NUMBER, iOutput out NUMBER, st out sampleType ); PROCEDURE uwelcome; END firstPackage; / create [...]
Answer Question
| November 9, 2004 10:41 PM
J2EE, Java, SQL
PL SQL Record in Java
Dear All I have a Stored Package written as follows: CREATE OR REPLACE PACKAGE firstPackage IS –Type definition TYPE sampleType IS RECORD ( name VARCHAR2(128), interface VARCHAR2(128), tablespc VARCHAR2(128) ); TYPE c_mx1_type IS REF CURSOR; –procedure definition PROCEDURE iwelcome( iNum in NUMBER, iOutput out NUMBER, st out sampleType ); PROCEDURE uwelcome; END firstPackage; / create [...]
Answer Question
| November 9, 2004 10:37 PM
J2EE, Java, SQL
Dear All I have a Stored Package written as follows: CREATE OR REPLACE PACKAGE firstPackage IS –Type definition TYPE sampleType IS RECORD ( name VARCHAR2(128), interface VARCHAR2(128), tablespc VARCHAR2(128) ); TYPE c_mx1_type IS REF CURSOR; –procedure definition PROCEDURE iwelcome( iNum in NUMBER, iOutput out NUMBER, st out sampleType ); PROCEDURE uwelcome; END firstPackage; / create [...]
Answer Question
| November 9, 2004 10:37 PM
J2EE, Java, SQL
DB2 SQL delete to purge Header/Detail records
I have a Header file with Detail records that belong to it. I need to copy the detail data off to a backup file, delete the detail records where the Header record entered date is greater than xx days from the current date, copy the header data off to a backup file and finally delete [...]
Answer Question
| November 15, 2004 1:16 PM
DB2, SQL
I have a Header file with Detail records that belong to it. I need to copy the detail data off to a backup file, delete the detail records where the Header record entered date is greater than xx days from the current date, copy the header data off to a backup file and finally delete [...]
Answer Question
| November 15, 2004 1:16 PM
DB2, SQL
String Search in Oracle SQL
Hi all, I need to scan a field for a specific string and exclude all records with that specific string. This string in the filed looks like this: ‘WRK 08:06, LNCH 00:54, GRACE 00:02′ I want to excule all records containg “LNCH” in the time_code field. I tried like but that does not seem to [...]
Answer Question
| October 28, 2004 7:24 PM
SQL
Hi all, I need to scan a field for a specific string and exclude all records with that specific string. This string in the filed looks like this: ‘WRK 08:06, LNCH 00:54, GRACE 00:02′ I want to excule all records containg “LNCH” in the time_code field. I tried like but that does not seem to [...]
Answer Question
| October 28, 2004 7:24 PM
SQL
Data Conversion on IBM AS/400
Hi, We’re converting some old master files in to new format files. These master files have around 58 million records each. We wrote COBOL programs to convert the format and write to the new files. In order to speed up the process we are splitting the each master file into 20 parts(i.e., 20 files and [...]
Answer Question
| October 27, 2004 2:00 AM
COBOL, Data analysis, DataCenter, Development, Disaster recovery software, ERP, Financial services applications, Help Desk, Incident response, Lifecycle development, Manufacturing applications, Office Applications, Programming Languages, RPG, Special-purpose software, SQL, Storage, SunGard Data Systems, Systems Union Group, Tech support, Transaction Systems Architects
Hi, We’re converting some old master files in to new format files. These master files have around 58 million records each. We wrote COBOL programs to convert the format and write to the new files. In order to speed up the process we are splitting the each master file into 20 parts(i.e., 20 files and [...]
Answer Question
| October 27, 2004 2:00 AM
COBOL, Data analysis, DataCenter, Development, Disaster recovery software, ERP, Financial services applications, Help Desk, Incident response, Lifecycle development, Manufacturing applications, Office Applications, Programming Languages, RPG, Special-purpose software, SQL, Storage, SunGard Data Systems, Systems Union Group, Tech support, Transaction Systems Architects
Can you suggest an alternative to an IN statement?
I’m running a query which contains an IN statement and even though the cost of the query is low, the performance is not ideal. Here is the problem: We categorize products by associating the items to branches on a taxonomy tree. Customers are able to browse products by category and in this case, a customer [...]
Answer Question
| October 21, 2004 3:56 PM
SQL
I’m running a query which contains an IN statement and even though the cost of the query is low, the performance is not ideal. Here is the problem: We categorize products by associating the items to branches on a taxonomy tree. Customers are able to browse products by category and in this case, a customer [...]
Answer Question
| October 21, 2004 3:56 PM
SQL
C# sample code for copying a table from oracle to ms sql with ODP.NET needed
I want to copy a table from an oracle database to a sql server using the odp.net provider. Because I just have the .NET Framework SDK and the Eclipse C#-PlugIn it is very difficult for me to figure out how I can code this in detail. I successfully read from an oracle table with a [...]
Answer Question
| October 21, 2004 9:01 AM
C, Oracle, SQL
I want to copy a table from an oracle database to a sql server using the odp.net provider. Because I just have the .NET Framework SDK and the Eclipse C#-PlugIn it is very difficult for me to figure out how I can code this in detail. I successfully read from an oracle table with a [...]
Answer Question
| October 21, 2004 9:01 AM
C, Oracle, SQL
Extracting records from Oracle based on a created time of a Unix file
I wish to extract updated records from an Oracle database using a scheduled PL/SQL based procedure run every 15 minutes. The last updated date/time is stored in a column, I am currently comparing using last_upd > (SYSDATE – 15/1440). However this meand that is the job fails and is re-run, some updated records will be [...]
Answer Question
| October 19, 2004 4:30 AM
SQL
I wish to extract updated records from an Oracle database using a scheduled PL/SQL based procedure run every 15 minutes. The last updated date/time is stored in a column, I am currently comparing using last_upd > (SYSDATE – 15/1440). However this meand that is the job fails and is re-run, some updated records will be [...]
Answer Question
| October 19, 2004 4:30 AM
SQL
Converting Upsized MS Access/SQL database and application to ASP.net for the web
I have no experience wih ASP or web server based applications, but I have an Access program that I need to put on the web. What is the easiest route to full web implementation for a program that is currently using Access as the front end for a 200+GB db? The application needs to be [...]
Answer Question
| October 22, 2004 5:46 PM
ASP.NET, SQL
I have no experience wih ASP or web server based applications, but I have an Access program that I need to put on the web. What is the easiest route to full web implementation for a program that is currently using Access as the front end for a 200+GB db? The application needs to be [...]
Answer Question
| October 22, 2004 5:46 PM
ASP.NET, SQL
database design-2
sir, i am developing the order-process mgt (3-tier intranet app)using jsp,java,javascript and mysql as backend. i have to store the data from the customer order-sheets. in this business, they organize the garments(product) according to the colour.then each color is divided in to sizes like s,m,l,xl,xxl. example: mens brief-bule-s-1000 nos. mens brief-bule-m-1000 nos. mens brief-bule-l-1000 nos. [...]
Answer Question
| October 11, 2004 6:16 AM
Development, J2EE, Java, JavaScript, JSP, SQL, XML
sir, i am developing the order-process mgt (3-tier intranet app)using jsp,java,javascript and mysql as backend. i have to store the data from the customer order-sheets. in this business, they organize the garments(product) according to the colour.then each color is divided in to sizes like s,m,l,xl,xxl. example: mens brief-bule-s-1000 nos. mens brief-bule-m-1000 nos. mens brief-bule-l-1000 nos. [...]
Answer Question
| October 11, 2004 6:16 AM
Development, J2EE, Java, JavaScript, JSP, SQL, XML
