• SQL script to disable views after a demo period.

    Hi, I have a sql view that I created for someone on a test basis. I want to create something (stored procedure, trigger, etc) that will delete or disable this view after a 30 day trial period. I prefer to make the view unvisible even to the "sa" administrator so that the view can not be recreated...

    Katiekat5 pointsBadges:
  • runScript() returning null

    Hello to all of the participants. This is my first blog. This is a program to execute .sql file which contains bunch of sql statements. I have used iBatis package it's compling and executing with out any mistakes, but resulting nothing. I have tried in both 2.3 and 2.0 release also. Can any one...

    Querier5 pointsBadges:
  • Display Query for OS/400 SQL script

    Is it possible to view the SQL that is generated by a query created in Query for OS/400. I have the query defined as I want it and would now like to give the SQL script to my development team to use in automating reports by accessing the database directly.

    Tomotsk75 pointsBadges:
  • 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 save it as an .sql file. If I select multiple...

    ADMIntegrated5 pointsBadges:
  • How to run SQL script with parameters in CL

    I have to call an sql script with parameters from an existing cl program that runs daily (in batch). If I call it from the cl program, it is giving me this error "Pointer not set for referenced location referenced".

    Ara5 pointsBadges:
  • Send a email with attachment?

    How do I send a email with attachment in a sql script using SQL2000

    Mistp00120 pointsBadges:
  • SQL Cursor to use or not to use

    Hi, I've been told to never use cursor in SQL, because of possibility of memory leak, etc. But I have no idea of how to implement my script without them. My script doesn't execute anything on the database, it simply use cursor to create another TSQL script that does the execution. EG. open cursor...

    Db23290 pointsBadges:
  • SQL script output to a file

    I am running ad hoc SQL scripts in iSeries Navigator (V5R4) and need to direct the output to a text file. Is there a way to do this? TIA... Steve B

    SBatSI415 pointsBadges:
  • Read Only Table

    I create a table in sql server 2k5, the script is look like this: CREATE TABLE [dbo].[tb1PmtD]( [PmtDLU] [int] NOT NULL, [PmtDInvLU] [int] NOT NULL, [PmtDAmount] [money] NOT NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[tb1PmtD] WITH NOCHECK ADD CONSTRAINT [tb1Pmttb1PmtD] FOREIGN KEY([PmtDLU])...

    Ipong40 pointsBadges:
  • SQL Script

    I am trying to write a sql script that will ask for a date range each time it's run. How do I do this?

    Ebethea5 pointsBadges:
  • Migrating shell scripts

    We have to move more than 250 shell scripts from a unix to a linux environment, and also 100 sql scripts. Could you please give me some steps or a check list to follow to migrate these from unix to linux?

    Chunter110 pointsBadges:
  • 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"...

    Ilfoprog50 pointsBadges:
  • 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 how ?

    21748165 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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 function be used to do this?

    Francissamonte15 pointsBadges:
  • 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...

    JARON5 pointsBadges:
  • SQL Scripting

    Using SQL and given table X with columns labeled A, B, C, and D – how do you get a list of data in column C when column A and B are the same?

    Tdwalton365 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following