What is the key for this relation?
Please look at the ERD http://www.mepopo.com/image/1/38504 If I mapping the ERD into relational database schema R(k1, k2, k3, a, b) (which is before normalization). What will be the key for R? Thanks a lot! Jean

Answer Question   |  June 11, 2013  4:55 AM
ERD, ERD (Entity Relationship Diagram)

MSDTC promoting a transaction only in some environments
We have a service which uses LINGTOSQL to process some updates on a remote SQL box.  On some machines everything is fine and it works without DTC enabled.  On other machines, that appear identical the transaction is being elevated to a distributed transaction and failing if it hasn’t been enabled correctly.  This is on SQL [...]

Answer Question   |  May 8, 2013  2:45 PM
DTC, SQL 2008, SQL 2008 R2

Which config file does MySQL use?
Hi, I’m having trouble with MySQL. My OS is IBMi V7R1. We are using MySQL 5.0.45 with zend server 5.6.0. The problem is that the MySQL server works fine in qp2term(shell) but ends immediately after start with zend server. Also, when I check the defaults config file for MySQL I get this message: Default options [...]

Answer Question   |  March 5, 2013  2:55 PM
MySQL, MySQL 5.0, Zend, Zend Server

SAN to SAN hardware level replicaiton to replicate MSSQL 2008 R2 databases
If SAN to SAN hardware level replication solution is implemented, how can we utilize this solution to transfer MSSQL 2008 R2 databases’ MDF and LDF files.

Answer Question   |  February 28, 2013  9:26 AM
MSSQL, MSSQL 2008, SAN

encryting output file from BCP
I am exporting data using BCP util, in SQL native format, creating an output format. The proces executes a stored procedure, creating a temporary table, and then the BCP exports the table to an output file, in native SQL. Is there a method to have this output file encrypted without a 3rd party process?

Answer Question   |  December 7, 2012  4:17 PM
BCP Utility, encrypt files

Security Awareness training for FTI
I am responsible for the Security Awareness program and I’m trying to put together my IRS Security Awareness training. I work for a government agency and we have to have annual training for security FTI (federal tax information) data, which is required by the IRS. I am looking for a video that we can distribute [...]

Answer Question   |  August 30, 2012  3:25 PM
FTI, IRS, security awareness training

how do I cause a field to be null, using DFU?
how do I cause a field to be null, using DFU to update/insert a record?

Answer Question   |  August 21, 2012  6:43 PM
DFU, Nulls

Query timeout expired – State:S1T00,Native:0,Origin:[Microsoft][SQL Server Native Client 10.0] on production server
Hello, I am getting the below error on customer production error, Query timeout expired – State:S1T00,Native:0,Origin:[Microsoft][SQL Server Native Client 10.0] The queries are forming on the fly using MFC’s record sets. if I try to run that queries on SSMS directly I am not getting that error. How to identify exactly which query leads this [...]

Answer Question   |  August 20, 2012  8:38 AM
Microsoft SQL Server, SSMS

Trigger Perormance Issues when Journalling Started
I have an external trigger program (RPGIV) that is added to about 50 files. Its task is to store record images upon insert, delete, update in any of the 50 files. It stores the images in another file (the monitor file) which also contains an identity field (generated always as identity). All files, including the [...]

Answer Question   |  August 11, 2012  12:57 PM
Journal, performance, TRIGGER

Getting SQLCODE -518, while running EXECUTE Statement after PREPARE Statement in COBOL
I am executing a dynamic SELECT query (No CURSOR- Normal SELECT) WS-STRING - SELECT MEMBNO FROM ENBMAS WHERE MEMBNO = “3535″  EXEC SQL                                     PREPARE SQLSELX FROM :WS-STRING  END-EXEC                               SQLCODE = 0 EXEC SQL                  EXECUTE SQLSELX END-EXEC             SQLCODE = -518 (THE EXECUTE STATEMENT DOES NOT IDENTIFY A VALID PREPARED STATEMENT) Please Help me out.. if [...]

Answer Question   |  June 3, 2012  1:38 PM
Dynamic SQL

Direct queries to mysql 5.0 on Windows Server 2003 from Oracle 10g on Solaris 8
I have Oracle 10g running on Solaris 8. I would like to do direct queries from this server to a table on a MySql 5.0 database residing on a Microsoft Server 2003. Are there step-by-step instructions around? ie. Drivers for both ends; admin/config on both ends, etc. Thanks.

Answer Question   |  February 28, 2012  9:02 PM
MySQL 5.0, Oracle 10g, Solaris 8, Windows Server 2003

Automated Query iSQL
I am very new to SQL and only have experience running my queries though iSQL Version 10 Build 3960 where I manually type (copy & paste) my queries. I would like to schedule a specific query to run at certain hours each day and then save the results to an excel or text file. Is [...]

Answer Question   |  February 28, 2012  12:33 AM
Automated SQL Query, isql, SQL

DB2 Recursive UDF
I am looking to create a SQL table UDF on my AS400(v5r2) that will return a listing of suboridinates for a given manager. Is it possible to use recursion? Since we are on v5r2 recursive SQL is not an option

Answer Question   |  February 28, 2012  9:29 PM
AS400 V5R2, DB2 SQL

AS400 – SQLRPGLE
Hi, We are moving Values to Database Fields using Embedded SQL Concept. In Embedded SQL, We can decide the Variable Names dynamically. Is it possible with Display File? why?

Answer Question   |  March 17, 2012  9:49 AM
AS/400 Display File, AS400 - Embedded SQL, Dynamic SQL, Embedded SQL, SQLRPGLE

upgrade SQL Server 2008 32-bit to 64-bit
We have a new SQL STANDARD SERVER 2008 R2 x64, and an existing SQL STandard Server 2008 R2 x32. I want to migrate the database from the old x32 bit to the new x64 bit machine. Has anyone got any information regarding this, or resource to research read up on. Thank you

Answer Question   |  January 1, 2012  11:54 AM
Microsoft SQL Server

conversion of oracle trigger to MS SQL
how can i convert an oracle trigger into MS-SQL?

Answer Question   |  October 12, 2011  1:49 PM
MSSQL, Oracle triggers, SQL connectivity, SQL Server

Ageing Report T-SQL
Im trying to write a query to retrive debtors ageing report in sql I have two tables [strong]1. Billing(billAmount,BillDate,AccountNo)[/strong] [strong]2.Payments(payAmount,payDate,AccountNo)[/strong] I need the output to show ageigng [strong]0-30, 31-60, 61-90, 91+[/strong] with the balances for each period The Billing table is pre-populated with the charges per month as per the amortization schedule when a client [...]

Answer Question   |  March 31, 2012  1:29 PM
MSSQL, SAP Aging Reports, SQL 2005, T-SQL

Converting a command to a Database File
I was wondering if someone can offer some code or a site that would show some code examples of what I am trying to do on my LPARs. I’ve created a DB file using command CVTWRKSBS so I could create an IBM query over it to see what subsystems are active on the LPAR. However, [...]

Answer Question   |  March 31, 2012  8:20 PM
AS/400 LPAR, Converting Commands, Database Files, LPAR, LPAR Configuration, OS/400 V5R4M5

MSSQL 2008 sudden and drastical slow down – IT telephony
Hi, I’m a newbie, greeting everybody from Hungary, and thanks for your time Generally the SQL system runs smoothly. There is a SP which runs two times daily, and it logs the begin/end times. It takes about 20 minutes each time, normally. Suddenly I see that it takes 3-4 hours. Each time the same degradation. [...]

Answer Question   |  March 31, 2012  6:28 AM
MS SQL Server, MSSQL, SQL 2008, SQL Server

DBF in AS/400 – last record written
Hi , There is  file which has 6 fields and the first four as its key. Is there any way to figure out which is the last record written into it.   Thanks

Answer Question   |  June 22, 2011  3:58 PM
AS/400, AS/400 Database File, Database Files, RPG, RPGLE