Search found 39 matches

by bensonian
Mon Jul 07, 2008 11:07 am
Forum: Data Quality Best Practices
Topic: IIS Quality stage logs info request
Replies: 2
Views: 19247

IIS Quality stage logs info request

Hi there, I have a few questions regarding QS logs. When we try to run a job, does IIS's QS generate logs. 1. where does it generate the logs? 2. Does it append the log file each and every time a job runs or does it totally write to a new log. Any info regarding the QS logs would be appreciated. Tha...
by bensonian
Wed Mar 26, 2008 12:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Web Services WSDL Definitions
Replies: 4
Views: 2598

Make sure

1.WSDL file definition is installed on your local machine
2. Import the WSDL and select that particular item (after once you imported it)
3. Parametrising might help.. i mean the key_service_path name
by bensonian
Wed Feb 13, 2008 2:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Suppressing leading Zero's of Decimal Data type
Replies: 4
Views: 2265

Actually i was doing a division operator on a varchar data type and even used type conversion function to change it to decimal data type. StringtoDecimal(). Still in the sequential file i could see leading zeroes. My decimal data type is of length 12 scale 8.
by bensonian
Wed Feb 13, 2008 11:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Suppressing leading Zero's of Decimal Data type
Replies: 4
Views: 2265

Suppressing leading Zero's of Decimal Data type

I was wondering if there is a function that could drop all the leading zeros off of a Decimal data type.
by bensonian
Tue Feb 12, 2008 8:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stored Procedure Calls using DS
Replies: 2
Views: 1721

Stored Procedure Calls using DS

Could any body shed some light on how to call a stored procedure in DataStage Job. The database is DB2 and OS is unix. Any help in this regard would certainly be appreicated.
by bensonian
Thu Nov 02, 2006 9:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ftp Enterprise (Target) Stage
Replies: 0
Views: 862

ftp Enterprise (Target) Stage

Could somebody please shed some light on FTP Enterprise stage as target under UNIX environment and all the properties that need to be defined. Appreciate your help hi there I was trying to write to a target FTP Enterprise stage and input being Sequential Stage. I am getting this Strange connection p...
by bensonian
Tue Oct 31, 2006 8:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ftp enterprise stage Target connection problems
Replies: 0
Views: 805

ftp enterprise stage Target connection problems

hi there I was trying to write to a target FTP Enterprise stage and input being Sequential Stage. I am getting this Strange connection problem which says invalid URI syntax and the message is as following : uri is having invalid syntax and in the properties window i have specified under TARGET : URI...
by bensonian
Thu Sep 07, 2006 1:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MS OLEDB Stage
Replies: 1
Views: 1674

MS OLEDB Stage

Hi I got a few questions regarding the stage. 1.Is MS OLEDB Stage a server job stage or can it be used for EE (7.5.1 ) too? 2. Say i wanna use the MS SQL Server Load Stage. Inspite of using an ODBC driver (either Wire or No-Wire protocols) if i wanna go for a OLE DB driver should i be using the MS O...
by bensonian
Fri Sep 01, 2006 11:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Loading to SQL Server
Replies: 2
Views: 1245

Loading to SQL Server

Hi

Is there a way/ stage to directly write target data to SQL server from DataStage 7.5.1 . My source is a flat file and with some basic business transformations can i load the data directly to SQL Server inspite of writing to a flat file and loading it.

All your help would be appreciated.