• Develop logic in Oracle SQL

    How to develop logic in Oracle SQL?

    saddammulla015 pointsBadges:
  • Where should I start my entry-level IT career?

    How do I start career in IT industry when I have got bachelor's degree a long time back. I do not have an experience in IT but in HR. I do not have an experience in Canada where I have migrated 9 months back. There are very few females in IT industry. Where should I start. I even thought of...

    rinkyyy35 pointsBadges:
  • ENCRYPT_AES return CCSID error

    Claude15 pointsBadges:
  • Converting the XML data into SQL table and how to move values to a CLOB variable.

    Can anybody explain with an example for converting the XML data into SQL table and how to move values to a CLOB variable. Because I've looked at lot of sites but still not getting a proper solution.

    Sasikumarr200 pointsBadges:
  • PLSQL code on iSeries

    Hi, I have a question as we have developed some plsql procedures on Db2 10.5 on windows & Linux. This is purely plsql code. as we need to run these procedures on all the databases under a particular instance. My requirement is can I use the same plsql code on Db2/400. I mean on iSeries. On...

    HABBIE860 pointsBadges:
  • Is SQL 2000 STD installed in Crystal Reports with an ISV?

    In Crystal Reports 9 is SQL 2000 STD installed with an ISV?

    kevin3215 pointsBadges:
  • Setting up a database server in-house

    Goal: add a database server for silo storage environment to meet client requirements. Send queried reports from shared SQL server to new database server to be accessed from website dashboards. What is the best server set up to accomplish this?

    SacredGrounds5 pointsBadges:
  • How to insert row number using SQL

    When importing data from Excel into MS Access, how do you insert a row number using SQL?

    JimStAubin201515 pointsBadges:
  • Find and Replace String

    How to find complete string e.g I have 2 strings in a file "TABLE" and "TABLE_NAME". I want to replace "TABLE" with "COLUMN" and "TABLE_NAME" with "TAB_NAME". My current script replaces "TABLE_NAME" with "COLUMN_NAME", which is not what I want.

    shrikantbothe25 pointsBadges:
  • AS/400 selective update with SQL

    Hi All, I am trying to create an SQL statement that will update many records based on a file containing fewer records. I can easily update ALL records in the primary file but I really only want to update those that need to be updated. In the item master file the cost has been changed for some...

    Ckelly0115 pointsBadges:
  • Non-Profit blues in affording a cloud base SQL that is HIPAA compliant

    We are a non-profit company that subcontracts to agencies that provides services to clients. These clients need to be certified for eligibility to receive these services every 6 months. Our funding source wants us to maintain some sort of system whereby the agencies updates each client as s/he...

    annstuart5 pointsBadges:
  • DFU (UPDDTA) and changing Keys

    DFU (UPDDTA) and changing keys - We support a number of users of the same software. then we try to change a key field in a file with DFU it doesn't always allow us to do so. Sometimes the user does not have access to the key field, sometimes they do. Each user is the owner of the file and has...

    Bamba6125 pointsBadges:
  • Force replace when backing up SQL database

    We're trying to back up our database using this code: sqlcmd -S servername -Q "BACKUP DATABASE [DBName] TO DISK = 'C:\backup.bak'" It's been working but there's one little issue: When the backup file already exists, the data gets appended to the file. We need it to replace the file. Is there a way...

    ITKE362,035 pointsBadges:
  • iSeries-AS/400 SQL

    I have a table in a test environment and need to update the same name table up in a production environment. This would be any table and here are things we won't know. We do not know if there is a key, field names, or what was changed. It could be any file. so this has to work for any table. I used...

    Pgmr4680 pointsBadges:
  • SQL stored procedure is taking too much time to execute

    One store procedure is working fine at one location. But the same store procedure is taking too much time to execute in different location on same network. What would be reason for this and how to reduce response time?

    mukeshkumar1225 pointsBadges:
  • Declare Cursor in AS/400 COBOL

    I have and SQLCBL program that declares a cursor, opens the cursor, and then does a fetch to process the data in the cursor. The fetch is not always retrieving the first record in the file. It's my understanding that the open positions the pointer right before the first record and that the Fetch...

    rdgribben15 pointsBadges:
  • Delete million of rows by ID in SQL

    We're trying to delete roughly 2 million rows from our PG database. We already have a list of IDs that need to be deleted but it's turning into a slow process. This is what I tried: DELETE FROM tbl WHERE id IN (select * from ids) So basically, this is taking about 2 days to finish. Is there a...

    ITKE362,035 pointsBadges:
  • Performing SQL Join equivalent in MongoDB

    Does anyone know of a way to perform a SQL Join equivalent in MongoDB? This is what I have right now: comments { uid:12345, pid:444, comment="blah" } { uid:12345, pid:888, comment="asdf" } { uid:99999, pid:444, comment="qwer" } users { uid:12345, name:"john" } { uid:99999, name:"mia" } And I'm...

    ITKE362,035 pointsBadges:
  • Extracting SQL query output in HTML file through UNIX script

    I have made a Unix script in which m spooling the output of a sql query in TEST>HTML file. Now I want to add colors and style tag in the output so as to make it more visually appealing.

    parnita5 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 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