Hi, How can I get all the table names of a bib by a SQL-query? Thank you.
Answer Question | April 17, 2013 7:34 AM
Bib tables, SQL, SQL development, SQL Query
I m having my SQL server on Machine A and i m starting one transaction on server from Machine B, now in between suppost Transaction from Machine B creates a new record in one of the table on server using insert into statement, after creating the record the LAN connection of Machine B is disconnected, [...]
Answer Question | October 21, 2008 10:44 AM
Database connectivity, SQL Server availability, SQL Server transaction logs
Hi I need to expand the column limit entry in sql can anyone help. example: defauld column limit is 1032. I would like to expand it to 5000 i will appreciate any help. thanks
Answer Question | October 20, 2008 8:16 AM
I’ve put data in a description field in SQL; how can I display it in ASP.NET?
Answer Question | October 17, 2008 8:15 PM
I am a very new user to both SQL and Oracle and I am hoping that someone can explain to me if there is a way to multiple tables in a schema to .sql Import scripts. I know that in TOAD, you can right click on a table and choose export from the list, then [...]
Answer Question | April 22, 2009 9:30 PM
Oracle, Oracle import/export, Oracle Table Export, SQL, Sql Script, TOAD
How can I execute 10 sql at one go ?
Answer Question | October 14, 2008 6:54 AM
DB2, QMF, Query Management Facility, SQL
I am new to AS/400 and we have a project wherein we have to display the records grouped by some fields. Is it possible to write sql statements within RPG program?? How???
Answer Question | August 22, 2010 4:48 AM
Embedded SQL, RPG, SQL, SQLRPGLE
Hello there I am new to sql and cold fusion I want to create a timepicker to execute an array of function at x time. whether in sql or coldfusion. Thanks in advance
Answer Question | October 14, 2008 1:12 AM
Cold Fusion, SQL, Time Picker, Web development
Generated my sql data and proceed to load data into a subfile. It works great except for one thing every time i leave the program and return back into the program, my subfile is load with my last search criteria and i don’t know how to clear the buffers or tempfiles or whatever sql does [...]
Answer Question | October 20, 2008 7:05 PM
Database programming, SQL, SQL CLOSE
I need to create a stored procedure in SQL where the clause WHERE is a parameter. Is this possible? If yes, how?
Answer Question | April 8, 2010 6:50 PM
Parameters, SQL, Stored Procedures
What is an example of a fast SQL to get duplicates in datasets with hundreds of thousands of records. I typically use something like: select afield1, afield2 from afile a where 1 < (select count(afield1) from afile b where a.afield1 = b.afield1);
Answer Question | November 25, 2008 9:33 AM
Database maintenance, Duplicate records, SQL
I need to get a grip on using the embedded SQL in an RPG ILE program using the word “CURRENT” and I need to know how this works (in laymens terms please.)
Answer Question | October 13, 2008 6:51 PM
Embedded SQL, RPG, RPG ILE, SQL
I am trying to connect to EDW data mart on a Unix server from an SQLRPGLE pgm using the embedded SQL CONNECT TO code. I am getting SQLCOD = -000000113 when in debug and the connection fails. I have the code I can send in an email if you want? BCL2008
Answer Question | August 21, 2010 2:57 PM
RPGLE, SQL, Unix
What issues do I face with database file compatibility if I migrate from 32-bit SQL Server 2000 to 64-bit SQL Server 2005?
Answer Question | October 9, 2008 12:38 PM
64-bit, SQL, SQL database replication, SQL Server 2000, SQL Server migration
HOW DO I UPDATE A FILED IN SQL THROUGH VB 2005?
Answer Question | October 7, 2008 2:40 PM
SQL, SQL connectivity, VB 2005, Visual Basic
I have a table that has a demand order and a supply order I want to search for a order in the demand order column it may have more than one supply order and then I want it to look to see if that/those supply order is in the demand column and if it is [...]
Answer Question | October 7, 2008 3:11 AM
SQL, SQL Server
hello guys I have recently started learning SQL and I am trying to install 9i (database or software where I can practice SQL quires). Long time ago I started learning SQL on that time it was personal oracle7 I installed and used to do my practice…but now I have heard that you can install 9i [...]
Answer Question | October 1, 2008 8:38 PM
Oracle 9i, Oracle installation, SQL, SQL queries
How can i remove all instances of the following from my database? <script src=http://www.jic2.ru/script.js></script> thanks Bosco
Answer Question | September 30, 2008 7:41 PM
Database security, SQL, SQL injection, Web security
I would like to know if there any examples of using the SQL CLI APIs in a COBOL/400 program that may help me in using the APIs to call a stored procedure and process the result set(s) . Thanks Mike
Answer Question | September 26, 2008 7:55 PM
API, CLI, COBOL/400, SQL, SQL stored procedures
We have a problem with the ERP system on our SQL database. Whenever an ERP form at our client’s end remains idle for 15 minutes, an error message pops up when the form is made active again. This message is: “FRM-40733: PL/SQL built-in DBMS_ERROR_CODE failed.” Our DBA team is blaming it on a network issue, [...]
Answer Question | September 26, 2008 3:38 PM
ERP, SQL, SQL Database, SQL Server errors