pl/sql fixed file creation
I am new to the pl/sql world. I’m ok with writing out a comma delimited file but I can’t figure out how to write out a file where the fields are fixed length. I could use some examples. thanks,

Answer Question   |  October 28, 2011  12:48 PM
PL/SQL, SQL

export xml file of new stored data into a folder through trigger in sql server!
Hello everyone , im newbie on SQL and need to make a trigger that generate an xml file of the new data whenever an action happens ( INSERT ), i looked around and found a clause that can query an output as xml format (FOR XML )but i cant make the actual (xml)file and put [...]

Answer Question   |  October 24, 2011  12:08 PM
SQL, XML

Question on Database Development Options
Our organization is going to build a database program where there will be millions of entries. Data entry will be done from around the country. The central server will be located in the capital city. Presently we use Windows OS, planning to migrate to Linux OS in next 4-5 years. I’d like to know the [...]

Answer Question   |  March 7, 2012  7:02 PM
Database, MySQL, SQL

Free SQL software with interface to enter data
Hi, I need to enter about 5000 lines of data with about 10 columns. and then i would query the data (by lets say sql, but i am open to suggestions). Can anyone recommend a simple freeware to use. My queries would be like ordering the data based on certain column, or getting to view [...]

Answer Question   |  October 17, 2011  10:08 PM
Data entry, Free software, Freeware, SQL, SQL Query

Return only one word– SQL
Hello, I have a column called Profile in a table and I am searching for a specific word in that column. I use the keyword LIKE with the wildcard (%) and that is working fine, but how do I have the query only return that word and not all the text in the Profile column. [...]

Answer Question   |  March 31, 2012  7:12 PM
Oracle, Oracle SQL, SQL, SQL Server

How can do iSQl*Plus login for DBA
I want to create iSQL*Plus login for DBA. How can i do this ?

Answer Question   |  March 31, 2012  4:25 PM
DBA, iSQL*Plus, SQL, SQL Plus, SQL Server

Finding Holes in Numerical Sequence
I need help in identifying the missing numbers in a large query. The only problem is that some of the numbers may be alpha and numerical combined or not-they are mixed. Yet all the numbers are in the same column.  The query looks like this SELECT MSPMP100.PRDNO,MSPMP100.CLASS,MSPMP100.DESCP     FROM CARF1.MSPMP100 MSPMP100                                          Where MSPMP100.CLASS= ‘72′ MSPMP100.PRDNO is the [...]

Answer Question   |  March 31, 2012  10:58 AM
Access Datasheet, AS400 iseries, SQL, SQL Query

SQL to query a file
I want to use SQL to query a file and summurize data, using multiple scalars( min, max, sum) and display the results on a workstation screen.  Can i use one select statement in RPG iseries or should I create a stored procedure?   Any code samples,etc would be greatly appreciated.  

Answer Question   |  March 31, 2012  4:31 PM
Open Query File, RPG, SQL, SQL Query

What is the best why to get started in DBA
I have some experiance in SQL and Access and all the other MS software too. I deal alot with spreadsheets, and database in my job. I work alot with the AS400 and do alot of queries throught MS Access. What is the fasted and tghe most inexpensive way to get to the piont of being self [...]

Answer Question   |  March 31, 2012  11:00 AM
Access, DBA training, iSeries database, SQL

t-sql and AS400
I want to develop a TSQL query. First I need to determine if all the numbers in one of the fields are in numerical order and also find the missing holes in the number sequence. Secondly I need to sort by another field and by a particular criteria.  The words that I need to sort-by [...]

Answer Question   |  March 31, 2012  12:34 PM
AS/400 Query, SQL, SQL Query, T-SQL

Data Fields outside of report section
I am looking at a previously written Crystal 8.5 report in which most of the data fields are outside of the report section. I can only see these fields if I reduce the report size to 50%. I have tried landscape orientation and adjusting the paper size to 11X17, but I still have many fields [...]

Answer Question   |  March 31, 2012  4:45 PM
Crystal 8.5, Crystal Reports 8.5, SQL, SQL Reports

Querying against Views vs Tables
I have a view that combine several tables, so that the view presents more information that each table taken individually. I want to write an “INSERT INTO … SELECT … FROM xxx” query. Should I use the View in that “FROM xxx” or should I expand what the view shows? What’s better in terms of [...]

Answer Question   |  March 31, 2012  3:38 PM
MySQL query, SQL

Updating a Date Time Field
I need to update the Confirmation Date Time field to NULL for a specific meeting but am unsure how to insert it.  The script below works for an individual but if they have more than 1 confirmation date it clears then all. Meet_Master.MEETING is where the meeting code AM2011 is. UPDATE   ORDERS SET CONFIRMATION_DATE_TIME = [...]

Answer Question   |  March 31, 2012  4:27 PM
Scripts, SQL, SQL 2005, SQL Server, SQL Server 2005

Update a Date_Time Field
I’m trying to update a DATE_TIME field to a NULL value. When I run the script below I get an error. Any ideas on what I’m missing? UPDATE Orders SET CONFIRMATION_DATE_TIME = ‘ ‘ WHERE ST_ID = 102690 ERROR: Msg 245, Level 16, State 1, Line 1 Syntax error converting the varchar value ‘Ê’ to [...]

Answer Question   |  March 31, 2012  3:05 PM
Scripts, SQL, SQL 2005, SQL scripts, SQL Server 2005

SQL REPLACE with pointer
I need to manipulate xml-files larger than char-field max-length allowed with RPG.   [strong]Background info:[/strong] My current solution uses a char-field… My app stores XML-files in CLOB-fields. I copy the xml-file from CLOB-field to a char-field: I then use %scan to find relative position of the string to be replaced, which is done using the [...]

Answer Question   |  March 31, 2012  11:32 AM
AS/400 SQL, RPG ILE, SQL, SQL Server, XML File Creation

Update SQL Server 2005 Scripts
I don’t right code & don’t have the confidence to try on my own so, I’m asking for help. I need to run an update script to clear out the data from iweb_conf_demo.Attendee_ribbons. Then I’ll need to run multiple scripts to update multiple records on the same field iweb_conf_demo.Attendee_ribbons for different groups of registrants. For [...]

Answer Question   |  March 31, 2012  1:19 PM
SQL, SQL scripts, SQL Server 2005, SQL Server Scripts

How to search more than a word in a column SQL database?
i have an array of words to be search in my sql database like: searchword = array(['Arrays','Logistics']) for word in searchword:     conn.BeginTrans()     cursor = conn.Execute(“SELECT idf FROM instance WHERE instance=’”+ word +”‘”)     conn.CommitTrans() but some of the searchword cannot be access eventhough it do exist in my database table. [...]

Answer Question   |  March 31, 2012  5:19 AM
Python, SQL, SQL commands, SQL Database

VS 2005 SQL Reports – Need to convert 5 character string to datatime
Hey there. I am relatively new to SQL and have a problem. I am building a report that gets a summation of a column called ‘Duration’. The datatype is char(5) e.g. “00:30″ to represent a half hour. I suppose I need to change the datatype to sum it but can’t figure out how to. What [...]

Answer Question   |  March 31, 2012  8:16 PM
SQL, SQL Server, SSRS, Visual Studio 2005, VS 2005

RPGLE Embedded SQL Not null
RPGLE Embedded SQL is getting a SQL0305 (SQLcid-305, sqlstate 22002) when fetching the next record from a view.  This is pointing to null values encountered.  /free                                                   exec sql                                                fetch next from C1 into :wtclaims                  ;  /end-free                                          Wtclaims is an Externally Described Data structure. There could be null values in any field in the ds over [...]

Answer Question   |  June 24, 2011  3:33 PM
AS/400, Embedded SQL, RPGLE, SQL

SELECT with LIMIT in AS/400
Hi all, On my AS400, I need to select the first 90 records from one file and insert them into another file, but all the time i got all records in my result file. Is there any way to use the parameter LIMIT with my SQL SELECT INSERT INTO LIB1/FILE1 (FILE1) SELECT DISTINCT                  (substring(FILE1, 1, [...]

Answer Question   |  June 14, 2011  6:40 PM
AS/400 Parameters, AS/400 Records, SQL, SQL Select