DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 11 matches
Author Message
 Topic: IConv, Century change Range
lateshj

Replies: 1
Views: 1370

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Nov 19, 2004 12:46 pm   Subject: IConv, Century change Range
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Hi,

I have written a very simple routine as below.
PDate = Trim(Arg1)

IDate = Iconv(PDate,"D")

Ans = Oconv (IDate, "D")

Following are some test results
Case 1
Input : 09-09 ...
 Topic: Failed to connect JobMonApp on port
lateshj

Replies: 11
Views: 11714

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 26, 2004 11:49 pm   Subject: Failed to connect JobMonApp on port
Pls note the following for JobMonAPP (Job Monitor):

1) JobMonAPP runs on the ports listed in the following file:

/ascential/apt/QX/etc/jobmon_ports

2) JobMonAPP can be started/stopped usin ...
 Topic: Error :::: APT_CONFIG_FILE must be set up to compile paralle
lateshj

Replies: 2
Views: 2077

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Mar 29, 2004 5:00 am   Subject: Error :::: APT_CONFIG_FILE must be set up to compile paralle
If you are sure about you Config file then

Check ur /tmp

bdf /tmp

If it is 100% then the error is because of that

Often when u get DS errors abruptly do give a check at /tmp....
that the ...
 Topic: Prism to DataStage
lateshj

Replies: 7
Views: 2118

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Mar 03, 2004 9:18 pm   Subject: Prism to DataStage
Hi,
Would just like to share some features related to the kind of work you are doing...

You can use the PweXport.exe utility provided by DS present at (<Client CD>\Utilities\Supported\PWE ...
 Topic: Vectors..using them
lateshj

Replies: 0
Views: 938

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Mar 01, 2004 2:28 am   Subject: Vectors..using them
DataStage® Release: 6x
Job Type: Parallel
OS: Unix
Hi,

I wanted to know how do we use Vector Columns.

Following is my code structure

1. Input: Sequential File (Col0,Col1,Col2)
2. Make Vector: converting the 3 columns int ...
 Topic: DataStage Installation is stopped with Some Message
lateshj

Replies: 4
Views: 2312

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Sun Feb 15, 2004 11:21 pm   Subject: DataStage Installation is stopped with Some Message
Hi
Based on my experience with installation of DS 6 on HP UX 11i
Check the following

dsadm user does not have full permission to the installables directory and all the files underneath it.

T ...
 Topic: Adding an hour to a timestamp column
lateshj

Replies: 11
Views: 14457

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Dec 23, 2003 1:49 am   Subject: Adding an hour to a timestamp column
Thanks Teej,
I also had a case opened with Support, not much help though. I did then implement my problem using a BuildOP..
Really enjoyed making one, My First One....

Adding the sample code ...
 Topic: Adding an hour to a timestamp column
lateshj

Replies: 11
Views: 14457

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Dec 05, 2003 12:05 am   Subject: Adding an hour to a timestamp column
Hi ,
I was exploring the Transformer functions and this did work to an extent

TimestampFromSecondsSince(3600, "2003-12-04 23:55:00")
Gives the output as
2003-12-05 00:55:00

However this ...
 Topic: Adding an hour to a timestamp column
lateshj

Replies: 11
Views: 14457

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 04, 2003 7:30 am   Subject: Adding an hour to a timestamp column
DataStage® Release: 6x
Job Type: Parallel
OS: Unix
Hi,
I need to add an hour to the value stored in a column of data type TimeStamp.

Could not find any direct function to do that ,

Could ne one guide me as to how to write such a code in data ...
 Topic: Number of users connected to DataStage Server
lateshj

Replies: 7
Views: 4147

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Dec 04, 2003 3:37 am   Subject: Number of users connected to DataStage Server
Hi
Not sure of any direct method, however try exploring the options in the DS Director..Job..CleanUp Resource;
Select the Show all process radio button; then for each process in the upper pane, yo ...
 Topic: unix connection error
lateshj

Replies: 8
Views: 2330

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Nov 18, 2003 9:34 am   Subject: unix connection error
I had got a similar error, and reason could be
1. MedClearODBC does not exists in the .odbc.ini file
pls check the name, case...

Latesh
 

 Jump to:   



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