• What should I do for my career: SQL or NoSQL?

    What should I do for my career: SQL or NoSQL? Please help me...I'm confused on what to do.

    madhanmohan15 pointsBadges:
  • How to remove specific lines from a text files using either vbs or bat.

    We have a text file that is a result of an export from an application we have. We use the following bat file to rename and remove blank lines from it based on the way it exports the export options/format cannot be changed. I would like a way to add to this bat file a method to remove specific lines...

    swinehart68031,050 pointsBadges:
  • What’s \’) in the SQL language?

    What does ') mean in SQL language?

    gracielahoria5 pointsBadges:
  • SQL command to remove number from within a character string

    What is the SQL command to remove a number from within a character string, when the number repeats later in the string? For example, '10PtreeGB-m1 01-01'. I want to remove the 1 after the m, but leave the rest of the characters unchanged (before and after)?

    mskent5 pointsBadges:
  • career advice

    i am a fresh graduate in petroleum engineering and wish to purse a course in sap, I have no experince in IT order than basic computer knowledge.I want a sap course that is related to my field (petroleum Eng) and also make me a consultant.I was looking at MM in sap until recently I met a friend who...

    Haller80 pointsBadges:
  • Documenting column in SQL table in QADBIFLD (AS400)

    When a table is created with SQL, several fields in the system cross-reference file QADBIFLD gets content (headings, defults a.o). I noticed that the QADBIFLD table contains a column named DBIREM (length 2000 bytes..). I also noticed that the old S36 IDDU actually put some documentation into this...

    DanTheDane2,555 pointsBadges:
  • How to keep whitespace in datagrid

    I have a simple .NET app. You key a SQL statement into a text box. It then connects to any one of 5 i-Series and returns a datagrid. I am curious as to how I can preserve the whitespace in the columns. These columns have some fields with data right and left justified. Other fields a large field...

    ToddN20008,335 pointsBadges:
  • Help with SQL query

    Dear friends, I am working on squirrel and wrote a query which is like this: select sum((coalesce((Sent_128),0)))*(365/(count(distinct(date_created))))/(((sum(coalesce((quantity2),0))/(count(distinct(date_created))))+(sum(coalesce((qu antity),0))/(count(distinct(date_created)))))/2) as "final" from...

    animeshdubeyad5 pointsBadges:
  • Getting one datatype by using PL/SQL function

    Hi, how would I get more than one datatype by using the PL/SQL function?

    swathinulakani15 pointsBadges:
  • Multiple SQL statements through OLE DB on DB2/400

    We have a third party application built on SharePoint, and we want to use DB2/400 on our System i for the application's backend database. The app uses ADO and OLE DB to query whatever database it links to, and the vendor has it working on a number of different databases, including DB2 on Windows...

    AndyFarrar15 pointsBadges:
  • Coding of MD5 file in SQL format as accessing and recovering password?

    Add two-factor authentication on clients accounts when clients make an account. We're also trying to put in a security question and the answer should be saved with md5 format in a SQL file so when clients try to reset his account, they should answer the security question. What's the coding to do...

    ravikumarhg5 pointsBadges:
  • SQL to go From N Rows to 1 Row and N Columns

    I would like to ask for your help one more time, if you may. I work for an insurance company and am facing a challenge. I have two tables as such: policy_table Policy_number 12345 98765 45678 Policy_id (PK) 1 2 3 endorsement_table Endorsement flood quake theft hurricane freeze-pipe fire dog-bite...

    Esdras25 pointsBadges:
  • Sum using SQL

    What I want to do is the following: Name_Patient......... amount........ xxxx aaa................................500.................500 bbb...............................500...................500 aaa................................500..................1000 I want to make the field named xxx to...

    mohammedwagihe5 pointsBadges:
  • Getting ORA-29283 error when opening CSV file using UTL_FILE.FOPEN

    I have a SQL script and all it does in to open a CSV file using UTL_FILE.FOPEN. I keep getting the ORA-29283 error.  I have an Oracle directory object pointing to the file location. Here is the code snippet: create or replace procedure "SKINNY" as v_inputfile            ...

    jkeri355 pointsBadges:
  • REGEXP_SUBSTR

    I have a CSV file and in the first column i want to find only the records that start with 'S-'.

    jkeri355 pointsBadges:
  • How Would You Define Database Concepts?

    I am recruiting for a DBA for an ecommerce company and so far every candidate I have submitted to the HM has been rejected as they "do not understand database concepts". Circling round to the rejected candidates they all comment the HM is asking programming questions yet when I ask the HM and...

    tekhunter5 pointsBadges:
  • How to convert a TIMESTAMP data field to a CHAR data field in SQL

    How can I convert a TIMESTAMP data field to a CHAR data field?

    Keifford5 pointsBadges:
  • Domino web query returns incomplete result set

    I've inherited a a web based application which when executed via the notes form returns a false result set. The sql query executes and returns the proper result set when run through query manager however, when executed via the Notes web form using the ALL ALL input search parameter only a partial...

    Wolfen400 pointsBadges:
  • SQL7917 job log message: Access Plan Not Updated

    SQL7917 Access Plan Not Updated message is being displayed in the job log thousands of times. What does this mean and how do we get rid of it?

    Pgmr4655 pointsBadges:
  • Adding a field when using SQL to copy a file on iSeries

    My company is upgrading some applications and I need to copy the data from current files into the new files. In some cases the new files have additional fields. Is there a way with sql to copy the current data and at the same time add either a default value or a running sequentional value to the...

    CLK35 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