473,320 Members | 2,004 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Proble with DB2 load with column declared as Generated always

i have an issue with DB2 load.
I work on mainframes .... using back end as DB2 table.

In Db2 table,

There one column which is declared as Genarated Always.
I took the extract from that DB2 table but I am not able to load that extract back to the table.
Please provide me the solution so that I will be able to load the table withh the extracted data.

---- Amol
Jan 28 '08 #1
3 5002
docdiesel
297 Expert 100+
Hi,

try "MODIFIED BY IDENTITYOVERRIDE" to bypass the GENERATED ALWAYS while loading.

Regards,

Bernd
Jan 28 '08 #2
Hi,

try "MODIFIED BY IDENTITYOVERRIDE" to bypass the GENERATED ALWAYS while loading.

Regards,

Bernd

I am using TSO FILEDB2. By using option 3.7 I can load or unload the table.
Where do I need to give "MODIFIED BY IDENTITYOVERRIDE"?
Jan 29 '08 #3
docdiesel
297 Expert 100+
I am using TSO FILEDB2. By using option 3.7 I can load or unload the table. Where do I need to give "MODIFIED BY IDENTITYOVERRIDE"?
I'm not used to DB2 on z/OS, but wherever you place the " ... INTO TABLE mytablename ", just add IDENTITYOVERRIDE after the tablename.

You'll find detailed information in IBM's online handbook at [1] .

Regards,

Bernd

[1] http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db2.doc.ugref/chload.htm#chload
Jan 29 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Shabam | last post by:
A web application of mine developed using C# + MS SQL runs fine normally. However when I stress test it with a load testing software (using about 60 simultaneous users) some instances start...
1
by: Ken | last post by:
Is there any way that a literal can be used for a field value in the load statement? The context is fixed-length record formats, db2 8.1 ese, aix 5.1. I'm performing warehouse and mart loads...
6
by: davvid | last post by:
hello, please I would like to know if it's possible to load data in hierarchical table structure with identity column used as pk (for all the tables) : I mean table root (Id_root(pk,identity...
5
by: Laurence | last post by:
I want to get the column name of a datagrid control. But DataGrid.Columns always return a collection of count 0. Thanks for your help in advance.
1
by: smauldin | last post by:
Creating a table with an identity column works fine create table test(a integer, id integer generated always as identity ) When I attempt to add an identity column it fails. create table...
5
by: Steve Bugden | last post by:
Hi, I would like to set the column widths in the ASP.NET GridView control at runtime I have tried the following: http://msdn2.microsoft.com/en-us/library/ms178296.aspx Which uses the...
17
by: Darek | last post by:
Hi, I have a table, something similar to: create table my_table ( id char(32) not null primary key, num integer not null, code varchar(2) not null, name varchar(60) not null,
0
by: Bob DiMonte | last post by:
Have some generated columns in a table. did and export of ixf type and ran: load from d:\dba\test_students.ixf of ixf modified by identityoverride messages d:\dba\test_students_imp3.txt insert...
1
by: Sebastian Ciesielski | last post by:
hello, my database has column defined as GENERATED ALWAYS: TXT_VERMITTLERNR VARCHAR(10) NOT NULL GENERATED ALWAYS AS (RTRIM(CAST(ID_VERMITTLER AS CHAR(10)))) ID_VERMITTLER is: ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.