Get all table names by SQL
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
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
Facing a problem while working with transactions
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
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
setting column limit entries in SQL
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
SQL
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
SQL
Displaying SQL data in ASP.NET
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
ASP.NET, SQL
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
ASP.NET, SQL
Multiple Tables to Bulk Import .sql script
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
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
QMF for Windows
How can I execute 10 sql at one go ?
Answer Question
| October 14, 2008 6:54 AM
DB2, QMF, Query Management Facility, SQL
How can I execute 10 sql at one go ?
Answer Question
| October 14, 2008 6:54 AM
DB2, QMF, Query Management Facility, SQL
Can you embed SQL statements in RPG program
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
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
Timed execute array or function
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
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
SQL – SQL Data is not clearing
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
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
Creating a stored procedure in SQL
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
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
Fastest “get duplicates” SQL
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
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
Embedded 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 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
Connect to Unix from iSeries
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
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
MIgration to 64-bit Sql Server
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
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
VB 2005-SQL CONNECTIVITY
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
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
Using answer as criteria in sql server
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
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
oracle 9i instalation
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
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
SQL Injection Removal
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
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
Using SQL CLI APIs to call an sql stored procedure on an AS400
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
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
ERP form error message on a SQL database
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
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
