DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 199 matches
Author Message
Resolved
 Topic: Previous Month Last Date
talk2shaanc

Replies: 9
Views: 4343

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Aug 19, 2009 11:27 pm   Subject: Previous Month Last Date
DateFromDaysSince(-1, stringtodate(right(0:MonthFromDate(CurrentDate()),2):'-':'01':'-': YearFromDate(CurrentDate()),"%mm-%dd-%yyyy"))
 Topic: Jobs Aborts
talk2shaanc

Replies: 7
Views: 2775

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Aug 19, 2009 3:12 pm   Subject: Jobs Aborts
The version is 7.5x2.
Its seems OS is a problem, for which reason telnet is not working. I installed the software on Windows XP it worked, but its not working on Windows Vista.
 Topic: Jobs Aborts
talk2shaanc

Replies: 7
Views: 2775

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Aug 18, 2009 11:18 am   Subject: Jobs Aborts
Is the version 7.5.2r2 or just 7.5.2? One supports running PX jobs while the other does not. ...

Is its 7.5.2...We have installed the software in past on other system as well, and it was working.
 Topic: Jobs Aborts
talk2shaanc

Replies: 7
Views: 2775

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Aug 18, 2009 9:40 am   Subject: Jobs Aborts
DataStage® Release: 7x
Job Type: Parallel
OS: Windows
I installed 7.5.2 on one desktop for training purpose. The server and client reside on the same system.
I created a simple job, which reads data from one file and writes to another file. "A simple co ...
Workaround Reported
 Topic: Transformer Field Limitation
talk2shaanc

Replies: 5
Views: 1388

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Mar 04, 2009 4:07 pm   Subject: Transformer Field Limitation
Empty and Null have different meaning. Most of the cases you need to handle NULL values properly, otherwise it will create so many problems even at run time. You can use NullToValue() function to hand ...
Workaround Reported
 Topic: Transformer Field Limitation
talk2shaanc

Replies: 5
Views: 1388

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Mar 04, 2009 3:00 pm   Subject: Transformer Field Limitation
There are some warning with the usage of DecimalToString function. I dont see this as an issue as it would be there even for second design.

The only message that could be an indicator is
##E TBLD ...
Workaround Reported
 Topic: Transformer Field Limitation
talk2shaanc

Replies: 5
Views: 1388

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Mar 03, 2009 4:38 pm   Subject: Transformer Field Limitation
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
I have a PX job that need to perform transformation on 278 fields in a file.
The transformation is simple to check empty and replace with "NULL".


Seq -->Trasformer --> DB1 ...
 Topic: Trap Duplicate record
talk2shaanc

Replies: 7
Views: 1841

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Sep 12, 2008 1:26 am   Subject: Re: Trap Duplicate record
Hi
I have record like this:-
Col1 Col2
1 a
1 b
1 c
2 d
2 e
2 f
I want to trap duplicate record in PX.
My output1 should be like this:-
Col1 Col2 ...
 Topic: Display Jobs in a Category
talk2shaanc

Replies: 20
Views: 5047

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Sep 11, 2008 4:01 am   Subject: Display Jobs in a Category
I got answer to both the questions. Actually jobs which were missed out through above command were not compiled; I would rather say they were never compiled. Once these jobs were compiled I was able t ...
 Topic: Display Jobs in a Category
talk2shaanc

Replies: 20
Views: 5047

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Sep 11, 2008 3:06 am   Subject: Display Jobs in a Category
DataStage® Release: 7x
Job Type: Parallel
OS: Windows
Hello,

I want to list all Jobs within a given "Category" using CLI commands.
I tried using dssearch command; but its not working as expected:

dssearch.exe -domain acc-gz3ve9aah8t:9080 -user ...
 Topic: Find all projects in Datastage
talk2shaanc

Replies: 4
Views: 1414

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri Mar 14, 2008 2:37 pm   Subject: Find all projects in Datastage
any utlity on client machine...?
 Topic: Find all projects in Datastage
talk2shaanc

Replies: 4
Views: 1414

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri Mar 14, 2008 1:09 pm   Subject: Find all projects in Datastage
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
How to find all projects created in datastage without using any of the Datastage Client tools?
The way we have DS_JOBS to find all the jobs within a project; is there any Universe DataBase where we c ...
 Topic: Index in a multi-dimensional Array/Matrix
talk2shaanc

Replies: 4
Views: 1285

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Jan 29, 2008 6:36 am   Subject: Index in a multi-dimensional Array/Matrix
there are several look into manual or help
if you are refering to Index function then that wont help.

I will explain my requirement. assume i have 3X3 matrix as

Bill Jon Pam
Male Ma ...
 Topic: Index in a multi-dimensional Array/Matrix
talk2shaanc

Replies: 4
Views: 1285

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Jan 29, 2008 5:31 am   Subject: Index in a multi-dimensional Array/Matrix
DataStage® Release: 7x
Job Type: Server
OS: Unix
I would like to find index of a string in a MATRIX/Multi-dimensional array.
Does anyone know a function to get the same?
 Topic: Search a Field in Datastage Repository
talk2shaanc

Replies: 6
Views: 2639

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri Jan 25, 2008 7:10 am   Subject: Search a Field in Datastage Repository
But you can use the Reporting Tool, which will transfer all actual available metadata to a Database which you can analyze the way you like it.
Metadata/table definition is NOT maintained properly. So ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours