Datatype selected was longnvarchar and the sizedefined is too long..
Did neone find the solution
Its urgent
Search found 37 matches
- Sat Mar 26, 2011 2:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to longnvarchar value in datastage
- Replies: 3
- Views: 3121
- Sat Mar 26, 2011 1:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to longnvarchar value in datastage
- Replies: 3
- Views: 3121
How to longnvarchar value in datastage
Hi all I am doing a look up from the ODBC connector component and trying to read the value of column A. Column 'A' is a longnvarchar but datastage is not able to read it , it is throwing an error. I tried setting the environment variable APT_DEFAULT_TRANSPORT_BLOCK_SIZE to its maximum value but it d...
- Tue Jun 02, 2009 5:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: See for Constraints in Transformer from Basic Routines
- Replies: 2
- Views: 1830
See for Constraints in Transformer from Basic Routines
I am using basic routines, is there any build in function where i can find if the given job, or given transformer has any constraints lets say I have a transformer name from one of my jobs, can i find if it has any constraints defined in any of its links
- Wed Apr 01, 2009 5:43 am
- Forum: General
- Topic: error:Datastage Manager
- Replies: 4
- Views: 4161
error:Datastage Manager
Hi,
While importing datastage job into my server
I got below error.
datastageserver version:8.0
Error:
Missing Identifier in job/exec job section
object: =
class=:job design
can anyone please help me ?
Regards,
thanks.
While importing datastage job into my server
I got below error.
datastageserver version:8.0
Error:
Missing Identifier in job/exec job section
object: =
class=:job design
can anyone please help me ?
Regards,
thanks.
- Mon Mar 23, 2009 2:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Partition in DB2 ref table Query Vs Data Stage partition
- Replies: 4
- Views: 3973
- Wed Mar 18, 2009 6:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Partition in DB2 ref table Query Vs Data Stage partition
- Replies: 4
- Views: 3973
My guess... Enable 'returns multiple rows' in lookup and set the missing option as 'continue'. Is it you who developed the job? Maybe you can shed more light on what you need to achieve. Hi All, As you suggested, I enabled 'return multiple rows' and set the missing option 'continue'.It did not work...
- Wed Mar 18, 2009 5:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Partition in DB2 ref table Query Vs Data Stage partition
- Replies: 4
- Views: 3973
Partition in DB2 ref table Query Vs Data Stage partition
Hi All, I wanted to perform some testing on one of existing jobs.In that job, source is a sequential file. They wanted to perform look up on DB2 table. Reference table query: SELECT LTRIM(RTRIM(VEH_IDENT_NBR)), LTRIM(RTRIM(SRC_TXN_ID)), SRC_VER_NBR , TRANSACTION_ID, RANK() OVER (PARTITION BY SRC_TXN...
- Fri Dec 26, 2008 2:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: need to ignore a record when reading the data using CFF Stag
- Replies: 1
- Views: 3473
need to ignore a record when reading the data using CFF Stag
Hi All, I am using Complex flat file stage to read complex flat file data from unix.I have put record type as Fixed,Missing file mode as Depends and Reject mode as Continue.As per my job design,CFF stage expects record length of 1521.However One particular record has only 613 at source. While readin...
- Fri Jan 25, 2008 5:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to delete a shared container
- Replies: 1
- Views: 1836
Unable to delete a shared container
Hi All, we have server shared container(ErrorHandlingContainerPSct) in dev environment. I want to import the new parallel shared container (ErrorHandlingContainerPSct) from prod to dev. For that, I want to delete the existing server shared container ErrorHandlingContainerPSct. It gives error like &q...
- Mon Sep 17, 2007 4:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to do that
- Replies: 1
- Views: 1467
how to do that
hi
how to check automatically all three files (including produt,geo,bas) are present are in the FTP server and to validate that each file's stats agree with manifest stats (both count and bytes must match) before the ETL process begins
how to check automatically all three files (including produt,geo,bas) are present are in the FTP server and to validate that each file's stats agree with manifest stats (both count and bytes must match) before the ETL process begins
- Wed Sep 12, 2007 6:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to manage that
- Replies: 1
- Views: 1313
how to manage that
Ability to manage and control access and usage of ETL processes based on user role - Admin, Developer, or Operator - Managed Manually in datastage any please help me
thanks
koti
thanks
koti
- Wed Sep 12, 2007 6:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to findout
- Replies: 3
- Views: 1961
how to findout
hi
Ability to send notification based on missing file or invalid stats if files missing and/or invalid stats
in datastage
Ability to send notification based on missing file or invalid stats if files missing and/or invalid stats
in datastage
- Wed Sep 12, 2007 3:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Ability to send notification based on missing file or invali
- Replies: 1
- Views: 1423
Ability to send notification based on missing file or invali
hi
Ability to send notification based on missing file or invalid stats if files missing and/or invalid stats
hoe to do that
thans koti
Ability to send notification based on missing file or invalid stats if files missing and/or invalid stats
hoe to do that
thans koti
- Wed Sep 12, 2007 3:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to manage that
- Replies: 1
- Views: 1294
how to manage that
Ability to manage and control access and usage of ETL processes based on user role - Admin, Developer, or Operator - Managed Manually
- Wed Sep 12, 2007 3:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: indexes
- Replies: 4
- Views: 2125
indexes
A number of columns used to process the dimensions (such as src_key columns) do not have indexes. Since lookups use these columns extensively, adding indexes will greatly speed up loading performance.