SQL Clustering
SQL Server 2000 As far as performance tuning, where can I find statistics or could you offer your opinion in the following scenario. Which offers better performance, running One server in Active mode and another in inactive mode, each with four processors or Running both servers in active mode, each with two processors. Please offer [...]

Answer Question   |  June 8, 2005  3:33 PM
Database Management Systems, Hardware, Servers, SQL, SQL Server, Storage, Windows 2000 Server

Oracle query to count rows in tables
Does anyone have a PL/SQL script to count the rows in all the tables in a given schema? No use reinventing the wheel… TIA, Mike

Answer Question   |  May 27, 2005  12:22 PM
Oracle, SQL, T-SQL

Problems in DDL trigger usage
Problems in DDL trigger usage. I have a problem in the usage of DDL trigger. I created a DDL trigger on a user schema on “AFTER CREATE” event to catch the creation script of the all database objects using the system variables ora_sysevent, ora_dict_obj_name, ora_dict_obj_type,ora_dict_obj_owner. And I am storing all the collected information in a [...]

Answer Question   |  June 3, 2005  10:18 AM
SQL

Calling External Procedure from Java Web based Application
Below given is a procedure to access a CL Program in iSeries from a Java web based program. create procedure libxxx/proc_name LANGUAGE CL FENCED EXTERNAL NAME ‘libxxx/clprogram’ PARAMETER STYLE GENERAL The external CL program has other calls to Cobol programs in the same library.The procedure is in a different library.The cobol calls does not have [...]

Answer Question   |  October 26, 2009  5:09 PM
COBOL, i5, IBM, IBM WebSphere, iSeries, J2EE, Java, OS/400, SQL, UDB for iSeries/i5

MSACCES to AS400
I am currently working on a project where I need to take files from a MsACCESS and transfer them to the Iseries possibly replacing them on a daily basis. I have been able to export them to the ISERIES manually, via the export on the file menu. I have not been able to find an [...]

Answer Question   |  May 27, 2005  8:34 AM
AS/400, Development, RPG, SQL, VB.NET, Visual Basic

UNIQUE vs DISTINCT, what’s the difference?
What is the difference between UNIQUE vs DISTINCT when used in a select statement? The result sets would seem to be the same, but is there a performance gain by using one over the other? If it matters, we’re on Oracle 9i

Answer Question   |  May 18, 2005  8:14 AM
SQL

SQL LEFT OUTER JOIN – Null handling: Indicator Variables
I am using SQL Left Outer Join in an SQLRPGLEI Declare Cursor statement. I need indicator variables of SMALLINT type to handle my null returns in FETCH statements. How and where do these have to be defined? There are no SMALLINT fields in the tables I am joining. Thank you in advance for your consideration.

Answer Question   |  May 16, 2005  12:35 PM
Development, RPG, SQL

SQL Left Join unmatched null handling.
I am using SQL Left Join. My null values in unmatched returns are producing the following message when I Fetch them into my host variables: (SQL0305)”A FETCH, an embedded SELECT, a CALL or a SET or VALUES INTO statement has resulted in a null value, but an indicator variable was not specified for host variable [...]

Answer Question   |  May 18, 2005  5:43 PM
RPG, SQL

Recordsets resetting to NULL in Visual Basic 6.0
Hello, I am experiencing problems with recordsets in VB, where they are losing there values, i ran through the program in break mode, if i hover my mouse over, for instance GRS!name or whatever, it pop up the correct value, but then if i move the mouse away and then return it, to refresh the [...]

Answer Question   |  May 17, 2005  1:28 PM
Development, Software testing, SQL, Visual Basic

Counting Problem – SQL Server 2000
Counting Records – SQL Server 2000 I need to count rooms sold. The problem is that a room can be sold more than once for any given trip. How can I retrieve all records including one instance where the room has been sold multiple times on a given trip? Example: Inv. Trip Room 1 A50805 [...]

Answer Question   |  May 9, 2005  6:12 AM
SQL, SQL Server

re-writing a stored procedure as a coldfusion document.
Hi, I was wondering if someone can help me please – i have the task of re-writing out database stored procedures as coldfusion cfc’s. THing is i haven’t really got much experience with coldfusion and was hoping that some kind person can help me out. I have enclosed one of our stored procedures. Appreciated any [...]

Answer Question   |  April 26, 2005  7:36 AM
ColdFusion, SQL

Dynamic Column name in a Cursor
My table has columns named as C1,C2,C3 so on. Each department in the has values only for a specific number of columns. That is, not all columns are used by all departments. In the code below the second cursor gets all the columns associated with a department. Since the nu,ber of column is unknown I [...]

Answer Question   |  April 27, 2005  9:01 AM
SQL

Sub-pgm is to calculate X to the power of Y and then return Z. (using RPGIV / RPGILE)
Hello Because I am new to RPGIV (existing using RPGIII) . Recently I need to write a sub-program using RPGIV (or RPGILE ? ). This sub-program will receive two parmerter (X , Y) and output one parmeter (Z) (which are in numeric format – BTW what is the max precision for numeric format in RPGIV [...]

Answer Question   |  April 23, 2005  1:39 AM
COBOL, Programming Languages, RPG, SQL

Sql in RPGLE
Does anyone know how to use variable field in ORDER BY field in embedded sql in RPGLE to sort by specific order ? I don’t want to hard code a field name.

Answer Question   |  April 22, 2005  12:03 PM
SQL

Calculation of (num) 1/n (square root) using RPG
Do any one know how to handle below formula using RPG or else method which can be implement on AS400 RPG program : The formula is (number ) 1/n 1/n = mean 1 over n square root N= certain number and with decimal digit eg. 1.21 Please send me some suggestion about this . Many [...]

Answer Question   |  October 23, 2009  7:41 AM
C, Programming Languages, RPG, SQL

Problem selecting unique MAX
We have a stored procedure that ‘selects max(nvl(fieldM,0),value)+1 from table where fieldA=123 and fieldB = 456;’. This value is then inserted back into the table into FieldM as a record fieldA=123, fieldb=456, fieldM=Maxvalue, and another IDfield. After about a couple 100 of these it is over, and the stored procedure will be concerned with a [...]

Answer Question   |  April 22, 2005  10:08 AM
SQL, Tech support

sqlserver 2000 stored procedures
Hi , i have the unfortunate task of time to integrate microsoft sql server 2000 stored procedures to mysql so that our software will work. Can anybody tell me if this can be done, if so how easy is it and how do i go about it? Thanks for your help andy

Answer Question   |  April 4, 2005  10:02 AM
ColdFusion, MySQL, SQL, SQL Server

AS/400 SQL V5R2 — updating new fields in a file with values from a different file
I added 2 fields to FileA (FldX and FldY) FileA has the key to FileB (KeyB) where these values exist. FileA: FldA, FldB, KeyB, new… FldX, FldY FileB: BKeyB, BFldX, BFldY This is probably simple for someone that composes SQL all the time but I’m having trouble coming up with acceptable syntax… Thanks for any [...]

Answer Question   |  April 1, 2005  10:15 AM
SQL

Help with VBA Code for retrieving data from a table in an MS Access Database
Hi, I’m new around here. I’m a student in the programming field. I have a question for those of you with experience with VBA, VB, or SQL coding languages. Basicly what I’m looking to do with my database is have it fill in the remaining related fields in a form when the Primary key field [...]

Answer Question   |  March 30, 2005  12:59 AM
Database, DB2, Oracle, SQL, VBA, Visual Basic

SQL Trigger to create .csv file
I need to create a .csv file out of table A upon the insertion of a record into table B. It seems to me that this should be easy to accomplish, but the only answer I can get from anyone is to do a scheduled DTS package, which means we are dumping this table every [...]

Answer Question   |  March 30, 2005  2:32 PM
SQL, SQL Server, SQL Server 2000