Replace an Exsisting Table
How are you putting data into the table? Access allows sql type queries. Use the truncate command: truncate table xyz; This will delete all the data from the table but keep the table structure intact.
View Answer
| December 30, 2008 4:22 PM
Microsoft Access, Microsoft Access tables
How are you putting data into the table? Access allows sql type queries. Use the truncate command: truncate table xyz; This will delete all the data from the table but keep the table structure intact.
View Answer
| December 30, 2008 4:22 PM
Microsoft Access, Microsoft Access tables
Accessing the Northwind database in SQL Server 2005
The Northwind database is the sample database for SQL Server 2000 and older. In SQL Server 2005 Microsoft removed the Northwind database and created the AdventureWorks database. Both can be found on <a href=”http://www.codeplex.com”>www.codeplex.com</a>.
View Answer
| December 30, 2008 2:10 AM
Northwind sample database, SQL Server 2005
The Northwind database is the sample database for SQL Server 2000 and older. In SQL Server 2005 Microsoft removed the Northwind database and created the AdventureWorks database. Both can be found on <a href=”http://www.codeplex.com”>www.codeplex.com</a>.
View Answer
| December 30, 2008 2:10 AM
Northwind sample database, SQL Server 2005
Indexes and abstracts in SQL Server
An index is an object in the database which contains one or more columns from a single table. The data within the index is sorted which makes it much faster to search than searching the table it self. There are a couple of blog posts which I’ve made about indexes. <a href=”http://itknowledgeexchange.techtarget.com/sql-server/back-to-basics-whats-the-difference-between-a-scan-and-a-seek/”>What’s the difference between [...]
View Answer
| December 30, 2008 2:08 AM
Abstracts, Indexes, SQL Server
An index is an object in the database which contains one or more columns from a single table. The data within the index is sorted which makes it much faster to search than searching the table it self. There are a couple of blog posts which I’ve made about indexes. <a href=”http://itknowledgeexchange.techtarget.com/sql-server/back-to-basics-whats-the-difference-between-a-scan-and-a-seek/”>What’s the difference between [...]
View Answer
| December 30, 2008 2:08 AM
Abstracts, Indexes, SQL Server
Query performance and tuning
In order to improve the performance of the query you can use NOLOCK for example SELECT b.id, b.name, ( t.id ) AS tag_id, ( t.name ) AS tag_name FROM blog_entry b INNER JOIN blog_entry_tag_jn btjn (NOLOCK) ON b.id = btjn.blog_entry_id INNER JOIN tag t (NOLOCK) ON btjn.tag_id = t.id thanx Danish
View Answer
| December 29, 2008 11:30 AM
GROUP BY statement, ORDER BY statement, Query optimization, Query performance, SQL, SQL development, SQL performance, SQL queries, SQL statements
In order to improve the performance of the query you can use NOLOCK for example SELECT b.id, b.name, ( t.id ) AS tag_id, ( t.name ) AS tag_name FROM blog_entry b INNER JOIN blog_entry_tag_jn btjn (NOLOCK) ON b.id = btjn.blog_entry_id INNER JOIN tag t (NOLOCK) ON btjn.tag_id = t.id thanx Danish
View Answer
| December 29, 2008 11:30 AM
GROUP BY statement, ORDER BY statement, Query optimization, Query performance, SQL, SQL development, SQL performance, SQL queries, SQL statements
Searching using Oracle Forms 6i
Thanks for replying when I search for a specific record using “select” statement, the record retrieved successfully but the error “FRM-40509:Oracle error:unable to UPDATE record” raises when I do some modifications and press save. On “display error” the error is “ORA-00001: unique constraint (SCOTT.PI_EMPLOYEEID_PK)violated” Kindly suggest me regarding this problem ASAP Thanking You in advance
View Answer
| December 26, 2008 3:55 AM
Data Manipulation Language, Oracle development, Oracle DML statements, Oracle Form Builder, Oracle Forms, Oracle Forms 6i
Thanks for replying when I search for a specific record using “select” statement, the record retrieved successfully but the error “FRM-40509:Oracle error:unable to UPDATE record” raises when I do some modifications and press save. On “display error” the error is “ORA-00001: unique constraint (SCOTT.PI_EMPLOYEEID_PK)violated” Kindly suggest me regarding this problem ASAP Thanking You in advance
View Answer
| December 26, 2008 3:55 AM
Data Manipulation Language, Oracle development, Oracle DML statements, Oracle Form Builder, Oracle Forms, Oracle Forms 6i
Hide Header In Access Report
Move the first down to above the second header. Then make the first header “not visable’. That wil put the report header on every page along with the field header.
View Answer
| December 25, 2008 9:43 PM
Access, Access reports, Database
Move the first down to above the second header. Then make the first header “not visable’. That wil put the report header on every page along with the field header.
View Answer
| December 25, 2008 9:43 PM
Access, Access reports, Database
converting text string to numeric
Dim MyValue MyValue = Val(“62″) ‘ Returns 62. MyValue = Val(” 8 67 3″) ‘ Returns 8763. MyValue = Val(“15 and 30″) ‘ Returns 15. More information on the VAL function <a href=”http://www.techonthenet.com/access/functions/numeric/val.php”>here</a> You could also try these functions: CDbl CInt CCur CDec Good Luck! -Flame If you are wanting to permanently change them, open [...]
View Answer
| December 24, 2008 5:45 PM
Access 2003, text to numeric
Dim MyValue MyValue = Val(“62″) ‘ Returns 62. MyValue = Val(” 8 67 3″) ‘ Returns 8763. MyValue = Val(“15 and 30″) ‘ Returns 15. More information on the VAL function <a href=”http://www.techonthenet.com/access/functions/numeric/val.php”>here</a> You could also try these functions: CDbl CInt CCur CDec Good Luck! -Flame If you are wanting to permanently change them, open [...]
View Answer
| December 24, 2008 5:45 PM
Access 2003, text to numeric
Setting run priority on prestart jobs
I believe the run priority and time slice are defaulted by the job “class”. So, do a WRKSBSD on the subsystem these jobs run in, use the option to display the prestart jobs and find the class. Then take a look at the class (WRKCLS) to see how it is defined. Personally, I would not [...]
View Answer
| December 23, 2008 7:29 PM
AS/400 Job Prioritization, AS/400 jobs, AS/400 performance, ODBC, QZDAINIT
I believe the run priority and time slice are defaulted by the job “class”. So, do a WRKSBSD on the subsystem these jobs run in, use the option to display the prestart jobs and find the class. Then take a look at the class (WRKCLS) to see how it is defined. Personally, I would not [...]
View Answer
| December 23, 2008 7:29 PM
AS/400 Job Prioritization, AS/400 jobs, AS/400 performance, ODBC, QZDAINIT
What are the possible situations where DB2 server FORCES to close the applications connected to it?
If your refering to the IBM System i or AS400 server, closing Qbatch or the jobq that the application is running in will stop the application.
View Answer
| December 23, 2008 5:58 PM
DB2, DB2 restart, DB2 stop, DB2 suspend, DB2 Universal Database, DB2 Update Query, DBFO, IBM DB2
If your refering to the IBM System i or AS400 server, closing Qbatch or the jobq that the application is running in will stop the application.
View Answer
| December 23, 2008 5:58 PM
DB2, DB2 restart, DB2 stop, DB2 suspend, DB2 Universal Database, DB2 Update Query, DBFO, IBM DB2
How to send the data from a Physical file to a Flat file
FAPH IF E DISK FSAAPH O E DISK A F SAAPH KRENAMESA100 IFTRF DS I P 1 80EDTE I P 9 100CCDE C READ APH 20 C *IN20 DOWEQ*OFF C Eval SAAPH = EDTE + CCDE <– assumes SAAPH has one field named SAAPH not sure you’ll like the results see alternative below C WRITESA100 [...]
View Answer
| December 23, 2008 2:51 PM
Flat files, Physical File, RPG, RPG error handling, RPG/400, RPG/400 field validation
FAPH IF E DISK FSAAPH O E DISK A F SAAPH KRENAMESA100 IFTRF DS I P 1 80EDTE I P 9 100CCDE C READ APH 20 C *IN20 DOWEQ*OFF C Eval SAAPH = EDTE + CCDE <– assumes SAAPH has one field named SAAPH not sure you’ll like the results see alternative below C WRITESA100 [...]
View Answer
| December 23, 2008 2:51 PM
Flat files, Physical File, RPG, RPG error handling, RPG/400, RPG/400 field validation
issue sp_helprotect
If you are passing the procedure a table name it should give you back a single row for each user and each right granted to the table. Can you post the code that you are running? We are having the same problem, and the reason is that we’ve removed select permission on one column in [...]
View Answer
| December 23, 2008 6:27 AM
sp_helprotect, T-SQL
If you are passing the procedure a table name it should give you back a single row for each user and each right granted to the table. Can you post the code that you are running? We are having the same problem, and the reason is that we’ve removed select permission on one column in [...]
View Answer
| December 23, 2008 6:27 AM
sp_helprotect, T-SQL
Script to restore database permissions during a migration to SQL Server 2005
<a href=”http://www.tek-tips.com/viewthread.cfm?qid=1324602&page=1″>This page </a> has some scripts which I wrote to do just that.
View Answer
| December 23, 2008 3:26 AM
Database permissions, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server Database Permissions, SQL Server databases
<a href=”http://www.tek-tips.com/viewthread.cfm?qid=1324602&page=1″>This page </a> has some scripts which I wrote to do just that.
View Answer
| December 23, 2008 3:26 AM
Database permissions, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server Database Permissions, SQL Server databases
Embedded SQL to process ALL members
Alias is the standard answer for all things SQL and member– but that seems to be limited to one member per alias. Logical file can be over all members but you will probably not be in the database engine that you would prefer. Phil
View Answer
| December 22, 2008 2:15 PM
AS/400, Embedded SQL, i, iSeries, Member, OVRDBF, RPG, SQL
Alias is the standard answer for all things SQL and member– but that seems to be limited to one member per alias. Logical file can be over all members but you will probably not be in the database engine that you would prefer. Phil
View Answer
| December 22, 2008 2:15 PM
AS/400, Embedded SQL, i, iSeries, Member, OVRDBF, RPG, SQL
Moving data from one DB to another DB in SQL Server 2005
Max_Var_Size is the length of the data in the variable length columns. If you are calculating the size of data then you will want to account for the size of the index.
View Answer
| December 20, 2008 7:29 PM
Data migration, Max_Var_Size, SQL Server 2005, SQL Server 2005 migration, SQL Server migration
Max_Var_Size is the length of the data in the variable length columns. If you are calculating the size of data then you will want to account for the size of the index.
View Answer
| December 20, 2008 7:29 PM
Data migration, Max_Var_Size, SQL Server 2005, SQL Server 2005 migration, SQL Server migration
Index Strategy for existing SQL Server 2005 project
I’m with you. I’m not really sure what your boss is asking for. An index strategy is to create the indexes which the poorly performing queries need in order to perform better. If I were you I’d go back to your boss and ask him what he’s looking for.
View Answer
| December 20, 2008 7:25 PM
Database index strategy, Index strategy, SQL Server 2005, SQL Server 2005 index strategy, SQL Server index strategy
I’m with you. I’m not really sure what your boss is asking for. An index strategy is to create the indexes which the poorly performing queries need in order to perform better. If I were you I’d go back to your boss and ask him what he’s looking for.
View Answer
| December 20, 2008 7:25 PM
Database index strategy, Index strategy, SQL Server 2005, SQL Server 2005 index strategy, SQL Server index strategy
Joining Tables in SQL Server
In SQL Server you can not create an outer join without specifying LEFT or RIGHT.
View Answer
| December 20, 2008 6:19 AM
JOIN statement, LEFT OUTER JOIN statement, OUTER JOIN statement, SQL Server development, SQL Server Query, SQL statements
In SQL Server you can not create an outer join without specifying LEFT or RIGHT.
View Answer
| December 20, 2008 6:19 AM
JOIN statement, LEFT OUTER JOIN statement, OUTER JOIN statement, SQL Server development, SQL Server Query, SQL statements
SQL Stored Procedure
As fare I know in SQL there no direct support for members of phisical file. My suggestons is to write external procedure for example in ILERPG. You can open specific member inside RPG with EXTMBR(….) and then return recordset directly form RPG. Alias <b>is</b> the support for *PF members.
View Answer
| December 19, 2008 4:54 PM
iSeries, ODBC, SQL, SQL stored procedures
As fare I know in SQL there no direct support for members of phisical file. My suggestons is to write external procedure for example in ILERPG. You can open specific member inside RPG with EXTMBR(….) and then return recordset directly form RPG. Alias <b>is</b> the support for *PF members.
View Answer
| December 19, 2008 4:54 PM
iSeries, ODBC, SQL, SQL stored procedures
Using the SQL IN clause in SQLRPGLE
I am doing this: d SelectedTypes s 30 Inz( *blanks ) d Qt s 1 Inz( X’7D’ ) // Build sql IN list values with report types requested For x = 1 to NbrOfTypes; SelectedTypes = %trim(SelectedTypes)+Qt+Type(x)+Qt ; If x < NbrOfTypes; SelectedTypes = %trim(SelectedTypes) + ‘,’ ; Endif; Endfor; stmt = ‘Insert Into qtemp/FILEA [...]
View Answer
| December 19, 2008 4:40 PM
IN statement, iSeries, iSeries development, SQL statements, SQLRPGLE, WHERE statement
I am doing this: d SelectedTypes s 30 Inz( *blanks ) d Qt s 1 Inz( X’7D’ ) // Build sql IN list values with report types requested For x = 1 to NbrOfTypes; SelectedTypes = %trim(SelectedTypes)+Qt+Type(x)+Qt ; If x < NbrOfTypes; SelectedTypes = %trim(SelectedTypes) + ‘,’ ; Endif; Endfor; stmt = ‘Insert Into qtemp/FILEA [...]
View Answer
| December 19, 2008 4:40 PM
IN statement, iSeries, iSeries development, SQL statements, SQLRPGLE, WHERE statement
Update a field in one table after the change on a field in another table using a trigger in SQL
I found a solution.
View Answer
| December 18, 2008 5:35 PM
SQL, Triggers
I found a solution.
View Answer
| December 18, 2008 5:35 PM
SQL, Triggers
How to implement Sleep logic not using sleep() need customized
In your example, you have a statement assigning a character value to what should be a number: g_sleep := ’1′ ; — this assigns g_sleep a string value ’1′, instead of a number value This may be the error, or if you declared the variable g_sleep as a character/varchar type, then the next statement would [...]
View Answer
| December 17, 2008 9:50 PM
DBMS_LOCK.SLEEP, PL/SQL, PL/SQL block, SLEEP Procedure
In your example, you have a statement assigning a character value to what should be a number: g_sleep := ’1′ ; — this assigns g_sleep a string value ’1′, instead of a number value This may be the error, or if you declared the variable g_sleep as a character/varchar type, then the next statement would [...]
View Answer
| December 17, 2008 9:50 PM
DBMS_LOCK.SLEEP, PL/SQL, PL/SQL block, SLEEP Procedure
