How do i replace a sql tables field value with another value
I have the following script that works in Access but not in sql. I trying to replace the the value in the field “RSAMSTORE” with another value I give it (i.e. 999994, etc.) when the data is displayed. In otherwords when the select distinct is ran instead of seeing the value in the table “RSAMSTORE” [...]

Answer Question   |  July 28, 2008  7:18 PM
SQL, SQL scripts, SQL tables

Want to extract the Zip file using DTS Package and also run the DOSBase Batch file with it
Want to extract the Zip file using DTS Package and also run the DOSBase Batch file with it? Hey i have Zip file which i want to extract using the sql script or using DTS Packages. and also want to run the Batch file from DTS Packge. its possible or not ? and yes then [...]

Answer Question   |  July 17, 2008  8:27 AM
Batch files, DOS Batch, DTS packages, SQL scripts

Restrict a script to reduce SQL injection attacks
I want to reduce SQL injection attacks. How can I restrict a script to execute one query at a time?

Answer Question   |  July 10, 2008  5:58 PM
Scripts, SQL injection, SQL scripts

Insert records between records in a file using RPG code.
Is there a way to insert a record in between records in a file? For example, a file contains 10 records (1 to 10). I want to insert a record in between records 1 and 2, thus record 2 will move to position 3, 3 to 4, and so on and so forth. Can SQL/Insert [...]

Answer Question   |  June 10, 2008  5:00 PM
RPG, RPG ILE, SQL scripts

sql scripts
Hi all, i’m updating a new ‘commun management’ software n i wanna update the database bcoz i added many extra tables. i did write scripts for all the tables this way: Create……….. Drop……….. Alter…….. so our clients would be able to have access to it. but i have been asked to write other ways script [...]

Answer Question   |  June 5, 2008  9:12 AM
Scripts, SQL, SQL scripts