Inserting 50000 rows using FORALL statement

How can we insert 50000 rows by using FORALL,please give me entire code?

Ramesh5530 pointsBadges:

Excel report from RPG or SQL

How do I produce an excel report via RPG or SQL inside an RPG program?

Taborly0820 pointsBadges:

Compare two file data row by row in SQL

I need to compare two files (Previous data and current data) with same fields but changed in some fields value in Current sheet. I want to compare both files and filter only those records which are changed.  Ex. Previous Data: Reference name Address contact 123A Jhon USA 123 123B Paul UK 457 123C...

sgautam11115 pointsBadges:

What’s the better option for SQL Where clause: IN vs. OR?

I'm working with my team on several huge databases and we need to know which would be a better option for us in the SQL Where clause: IN vs OR? Is there actually a difference between the two? Thanks so much.

ITKE1,067,535 pointsBadges:

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:

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:

Debug SQLCBLLE pgm.

Can anyone please explain the steps involved in the debugging of SQLCBLLE pgm.

mvrkrishna560 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...

ToddN200099,840 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: