How to Export a MS SQL Image column to a file.
I have pictures stored in a Ms Sql table in an image data type column. I want to be able to write the image(which is a JPG to a file. Is there a function in MS SQL 2005 or is another tool necessary?

Answer Question   |  March 17, 2010  3:36 PM
blob data, Image databases, SQL, SQL 2005

display file driven by cl
Is there a sample CL/SQL code on how to display a message on the screen based on the last record data in a table. there is a stat feild in my table for eg if stat is 1 then display test1 if stst is 2 then display test2

Answer Question   |  March 17, 2010  6:02 AM
CL, SQL

Systems Management Server console2003 remote tool
I’m running SMS 2003 SP3, now I reinstall my PC as Windows 7, after setup SMS administrator console on Windows 7, I found the remote tool can not connect to XP OS SMS client, for Vista/Windows7 SMS client, there are even no selection of remote tool from the console. Remote assistance is ok to connect [...]

Answer Question   |  March 15, 2010  5:36 AM
Remote access, Server management, SMS 2003, SQL, Systems Management Server 2003, Windows 7, Windows 7 deployment

Problems with SQL Server 2000
In my office we work on SQL Server 2000, and we have software in .NET Question 1: Sometimes the message display reads “You cannot access because of user limit”. What does this mean? Question 2: Some of my computers work slow in SQL for an hour or two at a time. What can I do [...]

Answer Question   |  March 12, 2010  6:45 PM
.NET, SQL, SQL Server 2000

Adding files to TempDB
Do I need to restart SQL Server 2005, if I have added additional files to the TempDB?

Answer Question   |  March 11, 2010  6:41 PM
SQL, SQL Server 2005, TempDBs

How to left or right justifying a text file
Hello programmers. I am using sql to create a table from stored procedures and then streamwriter in vb.net to create a text file based on the sql table. Where and how do I control the right or left justification of the records in the text file? Thx.   ip

Answer Question   |  March 11, 2010  8:38 PM
SQL, textfile, VB.NET

How should I make the SQL in iBatis having Parameter of ListMap?
How should I make the SQL in iBatis having Parameter of List<Map>? When I search primery key at a table having two primery key, I have plural parameters as a parameter. This parameter is List<Map>. It is an example of Parameter as follows EX) 1. parameter List<Map> paramList = new ArrayList<Map>(); Map<String, Object> map1 = [...]

Answer Question   |  March 8, 2010  5:17 AM
iBATIS, SQL, SQL Parameters

retrieving run time records in SQL
how to retrieve multiple rows at run time in sql

Answer Question   |  March 4, 2010  4:56 PM
Runtime records, SQL, SQL Runtime

SQL index on dds file
Will and existing rpg program that is doing a file read/table scan utilize an sql index with changing any of the rpg program?

Answer Question   |  March 5, 2010  2:43 PM
DDS, SQL, sql indexes

Documenting column in SQL table in QADBIFLD (AS400)
When a table is created with SQL, several fields in the system cross-reference file QADBIFLD gets content (headings, defults a.o). I noticed that the QADBIFLD table contains a column named DBIREM (length 2000 bytes..). I also noticed that the old S36 IDDU actually put some documentation into this column. Now my question: How can text-documenation [...]

Answer Question   |  March 2, 2010  10:12 AM
AS/400 SQL, Documentation, QADBIFLD, SQL, SQL generated files, SQL tables

SQL statements question
I have an accounts ENTRY table with many fields like (ac_bal, ac_id , ac_date, …etc) and I want to retrieve the summation of each account in each month as seen in the table below. 10-01 21-04 02-11-4 ….. jan Feb mar . . . Etc. Can anyone help?

Answer Question   |  February 18, 2011  7:54 PM
SQL, SQL statements

Using SQL and Postgre on the same machine
We have a requirement in which we need to have our Microsoft SQL Server, as a database of tomcat servers, and our Postgre SQL, as database of jboss servers, on same machine. Are there any known conflicts or issues we should be aware of?

Answer Question   |  February 24, 2010  9:21 PM
Database API, Postgres, PostgreSQL, SQL, SQL Server 2000, Tomcat

SQL for Microsoft Access
I have crated the below SQL statement. I works fine. and it gives me the required “RTCDate” I need, that which is difined at the Where statement of 3 - 2010. The other constraints are that I need all my 79 product line numbers. and the “1″ is those product line numbers that are active and current. So all the above [...]

Answer Question   |  April 5, 2010  12:24 PM
Microsoft Access, SQL

Auditing users of STRSQL
I want to audit the SQL statements of users who use STRSQL. I know if you press F13, you can change the interactive SQL Session Services. If you choose option 4 it will save all SQL statements into a file. But I was wondering if it is possible if we setup this as default when [...]

Answer Question   |  February 18, 2010  9:02 PM
SQL, SQL audit, STRSQL

SQL Access Query
I am using the book SQL for Microsoft Access. and the below statement is from the book and for some reasone I am getting a sytex error on the  word “Udate”     Why would that be?  CREATE TABLE Manufacture ( ManufactureID INTEGER CONSTRAINT ManfID PRIMARY KEY, ToyID INTEGER NOT NULL, CompanyName CHAR (50) NOT NULL, [...]

Answer Question   |  February 16, 2010  11:00 AM
Access Datasheet, Access query, Microsoft Access, SQL, SQL Access, SQL Query

Multiple databases on a server – SQL
My queries Can PostgreSQL(as database for a Jboss application) and MS SQL(as database for a tomcat application).Are there any known conflicts/issues ? Best regards

Answer Question   |  February 15, 2010  5:23 AM
PostgreSQL, SQL, SQL Database, SQL Server databases

about oracle with Java
What is future of Oracle with Java regarding jobs for freshers and distance learners. Why I am asking this because I am learning oracle from SQL star tutorial in delhi and doing MCA from Sikkim Manipal University in distance learning.

Answer Question   |  February 15, 2010  7:52 PM
Java, Oracle Careers, Oracle developers, Oracle with Java, SQL, SQL Plus

Help with embedded SQL in RPG. Dang thing hates the delete statement?
 H OPTION(*NODEBUGIO:*SRCSTMT)                             *******************************************************  FWRLDSHP   IF   E             DISK                       FWRLDSHP1  O  A E           K DISK                       D*******************************************************  D*  Working Variables                                    D*******************************************************  D                SDS                                     D PGMNAME                 1     10                       D*                                                       D myDS            ds                   occurs(60)        DXORDNU                          7a    varying           DXHIPDT                          7a                      DXSHPIN                         30a                      D*                                                       D i               s             20i 0 inz                D*                                                       D*INVDETL        E DS                  EXTNAME(WRLDSHP1)  C*                                                       C/EXEC SQL                                               C+ Set Option                                           [...]

Answer Question   |  February 17, 2011  7:55 PM
RPG ILE, SQL

Querying multiple member PF with SQL
I would need to SQL on a multiple member PF and I need to query the 2nd or nth member in the PF.  Is this possible just with an SQL query without using OVRDBF etc.?

Answer Question   |  February 15, 2010  8:17 AM
AS/400 SQL, DB2, Physical Files, SQL

File overrides within interactive SQL sessions – how are they applied?
I have an issue where, in an interactive SQL on an iSeries (V5r4) despite specifying the library and file name for a delete statement, the action deletes from a file listed in the overrides. Is there a way to prevent this from happening?

Answer Question   |  February 3, 2010  10:58 AM
AS/400, AS/400 SQL, iSeries, SQL, SQL Sessions, V5R4