Stack Overflow
Stack Overflow

Questions tagged [db2-luw]

DB2 for Linux, UNIX and Windows

DB2 for LUW is part of the DB2 family, that runs in these operative system.

Many parts of the internal structure are the same in all members of the DB2 family, but there are also things specific for each architecture.

This tag is for question related specifically to this member of the family.

913 questions
-2
votes
2 answers

DB2 - extended_row_sz pros and cons

Can you help me understand the pros and cons of using extended_row_sz parameter in DB2 settings level? Is that something can we set for a specific tablespace only? Without extended_row_sz setting enabled we are not allowed to create a table with…
Koushik Chandra
  • 1,565
  • 12
  • 37
  • 73
-2
votes
1 answer

Unable to fetch the column name in DB2

When I am using an expression as a column(without alias) in my query, the driver returns the column number, instead of the name How can I fetch the column names, instead of column numbers?
Ashish Ramtri
  • 81
  • 2
  • 10
-2
votes
1 answer

db2audit usage questions/clarifications

Bonjour friends, Does anyone have commands or steps to setup Db2 level auditing so we can look for which user(s) is using the database, when (timestamp) it was used and what that user did (eg which queries, tables, schema was…
Geraldine86
  • 1
  • 5
-2
votes
2 answers

DB2: SQL to return all rows in a group having a particular value of a column in two latest records of this group

I have a DB2 table having one of the columns (A) which has either value PQR or XYZ. I need output where the latest two records based on col C date have value A = PQR. Sample Table A B C --- ----- ---------- PQR Mark 08/08/2019 PQR Mark …
sam243475
  • 3
  • 2
-2
votes
1 answer

SQL to IBMDB2 syntax issue

I am trying to execute the following SQL script inside a IBMDB2- however unable to get the syntactically correct script for IBMDB2; BEGIN TRY BEGIN TRANSACTION if not exists (select * from AAA.BBBB WHERE COL1='[Param.1]' and COL2=[Param.2]…
Rajeev
  • 27
  • 5
-2
votes
2 answers

How do convert below code from T-SQL into DB2 LUW?

How do I convert this code from T-SQL into DB2 LUW, it seems so easy with T-SQL but in DB2 can't find any solution. See code below: DECLARE @sqlCommand varchar(1000) DECLARE @columnList varchar(75) DECLARE @city varchar(75) SET @columnList =…
GeekyDad
  • 75
  • 1
  • 7
-2
votes
2 answers

How to get the DB2 version installed in the machine whether it is 32bit or 64bit using batch file in windows

How to get the DB2 version installed in the machine whether it is 32 bit or 64 bit using batch file command in windows?
Shiv
  • 101
  • 3
  • 15
-2
votes
1 answer

Get Substrings From DB2 Column

I Have: AAAA/DATA1/Data2;xyx;pqr this data I want only:DATA1 And Data2
Balaji Dongare
  • 57
  • 1
  • 7
-2
votes
1 answer

Altering foreign key

Is there a way to add ON DELETE CASCADE option to an existing foreign key in DB2 10.5 without dropping and recreating said key?
abaritni
  • 1
-2
votes
1 answer

check constraint that references multiple columns in the same table

I am attempting to add a constraint to a DB2 database that will check three columns. I am using a table that is an invoice table that includes start date end date quantity item price etc. for each line item on an invoice. I want to prevent allowing…
Brendan Robert
  • 95
  • 9
-2
votes
1 answer

Why am I getting a syntax error when calling my stored procedure?

I am trying to call a stored procedure with Time variable as in parameter. But whenever i try to call the procedure i m getting error as: db2 'call PASS_FAIL_CHECKDATE('2014-01-21','13:42:25','CSS1',Null,'4500096651','10',Null)' SQL0104N An…
Anym
  • 1
  • 1
  • 3
-2
votes
1 answer

Detach and re-attach from db2 partitioned tables

I created a partioned table. But I used incorrect quotation syntax 'MAXVALUE'. This needs to be MAXVALUE as below. How can fix this problem? CREATE TABLE RMOBJECTSPAR ( "OBJ_LIBRARYID" SMALLINT NOT NULL , …
Mustafa DOGRU
  • 3,994
  • 1
  • 16
  • 24
-2
votes
1 answer

What is the simplest way to migrate data from MySQL to DB2

I need to migrate data from MySQL to DB2. Both DBs are up and running. I tried to mysqldump with --no-create-info --extended-insert=FALSE --complete-insert and with a few changes on the output (e.g. change ` to "), I get to a satisfactory result but…
John
  • 4,786
  • 8
  • 35
  • 44
1 2 3
…
60
61