• Encrypt a Column in SQL Server 2005

    I'm trying to encrypt a column. Unfortunately I don't have access to the C# source code that is accessing the data. All the instructions I've found require me to use the decrypt function in my SQL command. How do I automatically encrypt and decrypt without being able to change the source code? Is...

    Jfw10075 pointsBadges:
  • Store image from a directory into Oracle database using SQL

    I have a directory containing 1000s of photos which I have to upload into Oracle 9i DB. I need to use only SQL plus for this. I want a simple material to upload all those photos.

    cmuraz5 pointsBadges:
  • SQL optimization in COBOL400

    I am using an SQL in Cobol 400 to delete around 100 million records out of 200 million records based on a date. What is the best way to delete this much data in one stretch? The file has key as date. My sql would look like Delete from FileA where Date < 'some date'

    anuppdas105 pointsBadges:
  • 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!

    Ctc12320 pointsBadges:
  • Trying to use “Transfer data from iSeries add-on to Excel

    I am trying to use 'Transfer data from iSeries' add-on from within Excel. I have specified my library/file as : <><><><><><><> TANFILE/NCUFFLDR Data Option as: Select NCUFFLDR_COMPANY_TYPE Where (NCUFFLDR_COMPANY_TYPE=M)...

    CasNowak0 pointsBadges:
  • Difference between Structured Query and Query in AS/400?

    We used STRSQL- FOR START SQL(Structured Query Language) and STRQRY- FOR START QUERY. What is the difference between Structured Query and Query? (SQL and QRY)

    anupsshelke420 pointsBadges:
  • Difference between SQL Server 7 & SQL Server 2000

    Hi, Can you tell me difference between SQL Server 7 and SQL Server 2000?

    Marshal0 pointsBadges:
  • How to write SQLRPGLE query with many select criteria

    I have a report to print using SQLRPGLE. The Report criteria screen has around 15-20 select conditions. Based on the conditions entered by the user, I build a query of type: Select * from emp1 where val1 = ? and val2 =? and val3 = ? and........... This is the first time I'm dealing with so many...

    Nutangujar895 pointsBadges:
  • SQL query to find out policy numbers

    There are 2 tables POLICY and NAME. The relationship between POLICY and NAME is only the policy number. and their relationship is like many to one. I mean several policy numbers can have same name in the name table with that many records. Now my question is to find out the policy numbers having the...

    Deyyam0 pointsBadges:
  • SQL Query to return a single value for each record based on max FIELD, not max record

    I have a table with 12 date columns per record (D1 thru D12) and I want to select from each record, the max date of those columns (not the max of the records).  I know: select max(D1) from table1 will yield max of D1, but say I want D3 from record1, D1 from record2, etc (using the following...

    Schlingel0015 pointsBadges:
  • Error message CPF4326 appeared during OPEN for file EMPJ1 (C S D F). .

    Hi, I am getting the error below. What is this error...please explain it to me. Message ID . . . . . . : RNQ1216 Severity . . . . . . . : 99 Message type . . . . . : Inquiry Date sent . . . . . . : 08/18/13 Time sent . . . . . . : 14:11:56 Message . . . . : Error message CPF4326 appeared during...

    Jay1010 pointsBadges:
  • SQLEVN70.RLL

    How do you uninstall then re-run/install SQLEVN70.RLL on a IBM M/T 8104-C10 S/NL3RF550?

    2rick15 pointsBadges:
  • Data Conversion on IBM AS/400

    Hi, We're converting some old master files in to new format files. These master files have around 58 million records each. We wrote COBOL programs to convert the format and write to the new files. In order to speed up the process we are splitting the each master file into 20 parts(i.e., 20 files...

    DataConversion0 pointsBadges:
  • How to delete junk value records from a PF

    Hi, I have a file which has a date field of DECIMAL 8 and it has value +++++++++++ for some records. How can I delete these records via SQL or programatically.

    Ankitsikarwar10 pointsBadges:
  • PL SQL Record in Java

    Dear all, I have a Stored Package written as follows: CREATE OR REPLACE PACKAGE firstPackage IS --Type definition TYPE sampleType IS RECORD ( name VARCHAR2(128), interface VARCHAR2(128), tablespc VARCHAR2(128) ); TYPE c_mx1_type IS REF CURSOR; --procedure definition PROCEDURE iwelcome( iNum in...

    Tanmoychat0 pointsBadges:
  • Trigger or something like that for Select sentence

    I need a trigger or something which will be launch when i open a table with a "select" sentence...I know that triggers per se only work with "update, insert or delete" (DDL or DML) but I want to know if I can do something that works like a trigger but only when I do a "select" command...I know also...

    JorgeVergara0 pointsBadges:
  • How do I code this?

    LPAD(9999999 fixture,150,'') from item_loc_soh; I keep getting missing right parenthesis and I do not want the columns to display lpad or rpad

    bcarosi35 pointsBadges:
  • SQL and T-SQL

    If you are used to programming in SQL, will there be any issues with switching to T-SQL?

    lprice230615 pointsBadges:
  • To view the Oracle database table in all of the data record, will be stuck

    Query tables in the Oracle database with PL/SQL tools, can be successful, but when unwrapped all the rows of the table, will card to death. Different table, a table on the number of rows is different, but generally only 200 or so rows, then the SQL window card died (other SQL window can continue to...

    hjcj19891295 pointsBadges:
  • Where SQL statement is open ended

    Is it possible to have a where SQL statement that is open ended. I have notice that there are time that parameter box pops up with some the Access pass-through queries that I have.  Is it possible with SQL to be able to have a box pop up that would ask for a specific input to the...

    CompEng1,185 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