Search found 33 matches
- Sun Jul 31, 2011 10:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel execution of queries
- Replies: 1
- Views: 1311
Parallel execution of queries
Hi, We have a set of queries in a table as follows. For example Group ID SQL Query 1 Select * from table11 1 Select * from table12 1 Select * from table13 2 Select * from table21 2 Select * from table22 2 Select * from table23 2 Select * from table24 3 Select * from table31 3 Select * from table32 C...
- Mon Mar 31, 2008 6:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error when using Transformer stage
- Replies: 7
- Views: 6147
- Mon Mar 31, 2008 2:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error when using Transformer stage
- Replies: 7
- Views: 6147
Hi, We have re-installed Datastage but the problem is still persists. This time we are getting the error message as follows: Output from transformer compilation follows: ##I TFCN 000001 13:55:13(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2004, 1997-2004 Ascentia...
- Thu Mar 27, 2008 6:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error when using Transformer stage
- Replies: 7
- Views: 6147
Error when using Transformer stage
Hi All, We have installed Datastage PX 7.5.2x recently. We developed some sample jobs and the jobs are working fine if we don't use Transformer stage. When we are creating a job with Transformer stage, during compilation we are facing the below error. Output from transformer compilation follows: ##I...
- Wed Apr 04, 2007 2:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How the dynamic lookup is Achieved in Data Stage
- Replies: 9
- Views: 4062
- Wed Apr 04, 2007 2:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How the dynamic lookup is Achieved in Data Stage
- Replies: 9
- Views: 4062
- Thu Mar 29, 2007 12:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to write Routine ?
- Replies: 9
- Views: 5308
- Wed Mar 28, 2007 6:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to write Routine ?
- Replies: 9
- Views: 5308
- Tue Jan 02, 2007 1:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Adding a new column
- Replies: 8
- Views: 3750
Munish,
You can do as per the Balaji's suggesstion. Where are you getting struggled? In the column properties you can mention as follows:
Hope this will help you to resolve your problem.
You can do as per the Balaji's suggesstion. Where are you getting struggled? In the column properties you can mention as follows:
Code: Select all
Type=cycle
Initial Value=1
Increment=0
Limit=1
- Fri Dec 22, 2006 1:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to run the next job in the sequence?
- Replies: 3
- Views: 1802
- Wed Dec 20, 2006 6:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data type conversion function
- Replies: 6
- Views: 3034
Hi, I think you are in wrong way. Are you hardcoding the metadata? If yes, this is not a good practice to do so. Always it is better to import the meta data through Datastage Manager is the good way. length precision for a decimal value wth length as 9 and precision 2, i shuld define in datastage as...
- Wed Dec 20, 2006 3:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data type conversion function
- Replies: 6
- Views: 3034
- Wed Dec 20, 2006 2:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data type conversion function
- Replies: 6
- Views: 3034
Hi, APT_CombinedOperatorController,0: APT_Decimal::operator=: the source decimal has even precision, but non-zero in the leading nybble, or is too large for the destination decimal. Is your input column having any decimal values? If it is, then you can go for the function 'StringToDecimal'. (Since y...
- Mon Dec 18, 2006 7:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: conversion of julian date of format 'yyyyjjj' to date
- Replies: 10
- Views: 10143
- Fri Dec 15, 2006 1:25 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: reading sequential file as a single field
- Replies: 14
- Views: 4869
Hi,
Try with Field Function.
This will give you only the date part, so you can store it in a table.
Hope this will help you.
Try with Field Function.
Code: Select all
Field(i/p_col_name,~,4)
Hope this will help you.