SQL Syntax Error SQL0104
I have to recreate a duplicate logical file, but I can’t use the crtdupobj command because it doesn’t recreate the correct library pointers. Using the dspfd command. I’m attempting to recreate the logical file in a different environment(library). Using the exact same commands (different library) I’m attempting to create the file in SQL using the [...]

Answer Question   |  May 26, 2010  6:37 PM
SQL, SQL error messages, SQL Statement Syntax Errors, Syntax errors

Trouble creating SQL statement from MS Access Form
I’m creating an INSERT statement from the text fields in a form. This is a snippet: mySQL = mySQL & Combo0 & "','" & Text3 & "','" & Text5 & "','" & Text7 I am alternating the double and single quotation marks to enclose the entire statement as a single STRING while using the single [...]

Answer Question   |  May 10, 2013  9:51 PM
Access 2007, Microsoft Access, SQL, VBA, Windows Vista

Script to add a Period after a Middle Inital- Then query AD for User ID
I would like to create a script that parses an excel spreadsheet column with user’s full names (I.E. ‘John A Smith’) and inserts a period (.) after the middle inital character. (I.E. ‘John A. Smith’) Once the middle inital period has been inserted, I would like the script to query Active Directory using the User’s full [...]

Answer Question   |  May 20, 2010  6:38 PM
Active Directory, Excel 2003, SQL, User account management, VBScript

MySQL brain teaser
This has been driving me crazy. I’m trying to come up with an UPDATE query in MySQL that will remove the second blank space in a name and close the gap.   Example: O Brien, John E should become OBrien, John E   A simple REPLACE (name, ‘ ‘,’’) where SUBSTRING (name,2,1) like “ “ [...]

Answer Question   |  May 19, 2010  3:00 PM
MySQL, MySQL query, SQL

retrive data from 3 tables
HI i need to retrieve data of 3 tables using one more master table wat are the possible options Union,Joins anything else? with good performance please guide for considering the performance as the retrival count is huge in my case

Answer Question   |  May 21, 2010  8:31 AM
Oracle, SQL, TOAD

Editions of SQL Server
Can you briefly discuss the different editions of the database that are available now?

Answer Question   |  May 5, 2010  8:10 PM
SQL Server 2008 R2, SQL Server availability, SQL Server Version Comparison

Any Python use?
I know of a port to iSeries from way back. Wondering if there much use? I find that for some tasks, it can be more expressive than RPG. Especially useful if you have an ORM to help with table / SQL generation. Or if you want object orientation.

Answer Question   |  October 10, 2010  8:15 AM
AS/400, Python, RPG, SQL

SQL EXCEPTION JOIN
I have three files (orderinfo, deliveryinfo and itemlines). The three files entries shall exist as 1 to 1 to many. The files contains orders from 10+ years. Thus data has been migrated several times by various people. I have discovered that the one-to-one-to-many rule has been broken for many orders. I wrote a pgm to [...]

Answer Question   |  May 4, 2010  1:01 AM
SQL, SQL Exception, SQL EXCEPTION JOIN, SQL join

SQL record with latest date
if there is one table with a id and names as cloumns and another table with the id and dates, if want to have a id, name and the latest dates as an id can have mulitple dates what would be the query

Answer Question   |  April 28, 2010  4:01 PM
SQL, SQL tables

Storing array values into an Access database table from a program
Hi, I’m trying to write a program that stores the values in an array into a database table. The name of the database is Company.mdb and the table that I want to store values is called Employee. Below is the procedure that is supposed to perform the task. The problem is it doesn’t store the [...]

Answer Question   |  April 26, 2010  9:50 AM
Array, Database, MS Access, MS Visual Studio 2005, SQL

SQL Join on multiple columns?
Can I join from one file to another on more than one column? For example, join from FileA to FileB on OrderNumber.A=OrderNumber.B AND ItemNumber.A=ItemNumber.B? All examples show only one column… I am on an AS400 using RPGLESQL, I need to join from one detail file to another detail file.

Answer Question   |  April 25, 2010  6:50 PM
AS/400, JOIN statement, SQL

How do I find the timestamp associated with HWM of processes/sessions in Oracle 10g on AIX
The following SQL produces a very useful report of current resource utilization at the time of the query and the HWM since the database was started. What SQL can I add to list the time of the HWM? Database & ‘OS = Oracle 10.2.0.4 running on AIX 5.3.0.0 5300-09 64-bit. Thanks, Bruce col resource_name format [...]

Answer Question   |  April 23, 2010  4:06 PM
AIX, HWM, Oracle 10g, Oracle High Water Mark, SQL, SQLPlus

Need a sample code for Sql fetching multiple rows
In Native cobol we use read PF file in a loop until EOF to fetch all records.Now i need to do the same by using Sql in cobol,eg: select * from File and show it in subfile.Can anyone help me how to do this. How to move recods from curson to screen.Thankx in advance for [...]

Answer Question   |  April 19, 2010  8:55 AM
SQL, SQLCBLLE

SQL to edit last character in a field using STRSQL
I can select the rows using this SQL how can I update? UPDATE mbmtest01/itemaster SET right (ITNBR,1) = ‘ ‘ WHERE right(ITNBR,1) = ‘M’

Answer Question   |  April 9, 2010  5:24 PM
AS/400, SQL

DR/HA questions with SQL Server design
Greetings! I need your advice for two questions. This is related to design. I have a production site. It requires HA. At the same time we have a DR site. The DR site needs to have the same copy of the database for my application to run. Question 1: Is it advisable to have mirroring [...]

Answer Question   |  March 31, 2010  10:16 PM
SQL Server, SQL Server availability, SQL Server backup and restore

Substring Query SQL
Hi All, I’m trying to build a query to join names in one table to abbreviated names in another table. So for example I have – Harry Harold Harrison on one table, but in the other table I have just Har, this can vary in length so does anyone know how I can sum the [...]

Answer Question   |  March 30, 2010  12:44 AM
SQL, SQL Server query optimization

HOW TO CONNECT VS2005 TO SQL2005
Dear sir, how to connect vs2005 to sql2005 and which setting do in vs2005 and sql2005    

Answer Question   |  March 29, 2010  3:59 AM
SQL, SQL Server 2005, Visual Studio 2005

Sql Server 2005 ensure columns sum within a table
how can i ensure the total sum of 5 columns within the same table equals 100 during insert or update in SQL Server 2005?

Answer Question   |  March 29, 2010  11:47 PM
SQL, SQL Server 2005

using group by by joining 2 tables SQL
there are two tables employees and jobs .employees table attributes are job_id and salary.jobs having attibute job_id,job_title.i want to retrieve sum(salary),job_title  group by job_id

Answer Question   |  March 26, 2010  2:36 PM
SQL, SQL Anywhere Studio/M-Business Anywhere/Avantgo

Get your FREE ITKnowledgeExchange.com sticker
Be proud to show off you are part of the community with your free ITKnowledgeExchange.com sticker. All you have to do is answer a question and email me your handle and address and we will get one out in the mail to you. Allow 4-6 weeks delivery. Even if you have one already get one [...]

Answer Question   |  September 1, 2011  3:15 PM
CIO, CRM, Database, DataCenter, Domino, Exchange, Linux, Networking, Oracle, SAP, Security, SQL, SQL Server, Storage, Virtual Server, VoIP, Windows