• Migrate SQL .bak file to iSeries

    How do I migrate from an SQL .bak file to the iSeries?

    pgmr85 pointsBadges:
  • SQL convert numeric to date format

    How can I convert an 8 digit numeric (format ccyymmdd) into a real datefield to be used in date arithmetics? I need to calculate the number of months between the month (current date) and a date represented in my DB as an 8 digit numeric with format "ccyymmdd". Therefor (I assume) I need to convert...

    DanTheDane2,555 pointsBadges:
  • Embedded SQL using quotes to build field with wildcard

    How do I set up a cursor in RPGLE to select where a field is LIKE a character field using quotes with a wild card? The character field is a variable declared and built using a field in the program.  I have tried field LIKE :newfield with newfield setup as '%ch%' (single quotes). I tried field...

    cblanch25 pointsBadges:
  • Select number of employees gender wise in each department

    select number of employees gender wise in each department. In the employee table, gender of employees is stored whereas department number is stored in works_on table.

    aamirsuhail25 pointsBadges:
  • Is it good idea to change Simple Recover Model into Bulk-Logged on ETL system?

    We are having an ETL process which inserts lots of data into tables. This database is set to Simple Recovery Model and the transaction log is growing a lot. I was thinking that would it help to set this database into Bulk-Logged Recovery Model? We are taking full backups on daily basis. So is there...

    bugarl5 pointsBadges:
  • I need a formula to map the computed for display item in LEI

    I'm working on a LEI to transfer LN data to SQL. To do this, we have to map the LN fields and SQL columns. Problem here is that LEI does not support computed for display items. These items can be seen in the document properties list so i hope there should be a way to map them in the LEI using the...

    JDJeetya5 pointsBadges:
  • iSeries database update via CL

    Hi! I have an iSeries database table that has a column name JOBQ. I want to update all records with JOBQ value QBATCH into 2 different jobq names for alternate records. I'm a CL programmer and looking for an example of updating a column via SQL that I can call from my CL in a loop.

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

    ToddN20009,815 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:

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