Search found 13 matches

by mf_arts
Mon Jul 15, 2013 6:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Convert Dates
Replies: 5
Views: 4000

How to convert dates

Hi rajendra_89 You need to be more specific, what sort of converstion are you trying to achieve? For example: 1- if you want to change from mm/dd/yyyy and the desired output is yyyy/mm/dd you may use the foolow: Oconv(Iconv(DateAttribute,"DMDY"),"D/YMD[4,2,2]") 2 - If you want to...
by mf_arts
Tue Jun 15, 2010 3:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Server Job Import Issue in 8.1
Replies: 10
Views: 5979

Hi Sachin, In first place take a look to the IBM manual IBM Information Server Planning, Installation, and Configuration Guide shipped with the product, in particular Migrating from DataStage Version 7.5 to WebSphere DataStage Version 8 (search for this string in the pdf) then you might want to try ...
by mf_arts
Thu Jun 03, 2010 3:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Environment variables
Replies: 12
Views: 5537

It would be a good start to take a look to Parallel Job Advanced Developer Guide manual.
by mf_arts
Wed Apr 14, 2010 5:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage adminstrator
Replies: 5
Views: 2994

Hi Mayura, Create a Server job insert either an Universe Stage or a Hash File Stage as a source stage, put some transformer in the middle and a Sequence File as Target stage, link source to transformer and transformer to target stage. To configure UV stage in Stage tab define Data Source Name as loc...
by mf_arts
Tue Apr 13, 2010 9:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Install InfoSphere Information Windows 2003 Serveur 64 bits
Replies: 2
Views: 3313

Hi, Take a look in this IBM site: http://www-01.ibm.com/support/docview.wss?uid=swg27009462 Then search for : IBM Information Server Planning, Installation, and Configuration Guide, this manual and release notes are shipped with the product (Client), however you need to install the Documentation lay...
by mf_arts
Tue Apr 06, 2010 3:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How does authentication of user id and password happen.
Replies: 3
Views: 2312

Hi All, In version 8.x authentication is set through WebSphere application Server (WAS) and is used to authentication and security. There are three authentication registries: - Internal registry(default optin during installation), users and passwords are encrypted in Metadata Repository(DB2 by defau...
by mf_arts
Mon Mar 22, 2010 4:36 am
Forum: General
Topic: Datastage Certification
Replies: 9
Views: 5979

Hi,

Perhaps the appropriate path is something like:
DataStage Training (IBM recommended) Development (at least 6months) Certification (prepare yourself before apply) and then with some knowlaedge you might do the exam easly.
by mf_arts
Wed Jan 20, 2010 7:41 am
Forum: IBM QualityStage
Topic: Use of the Filescan utility on Unix
Replies: 4
Views: 2456

Hi Martina, As you said, Filescan utility is used to get the record lengths for a given file, once you execute FS then you have to match with your QualityStage file definition. To run Filescan in Unix (is located in your QualilyStage bin directory) you need to set $INTBIN to be able to run this util...
by mf_arts
Fri Dec 18, 2009 10:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage server file system full
Replies: 4
Views: 7404

Hi Rai, The scratch disk is defined on configuration file as below example: { node "node1" { fastname "Servername" pools "" resource disk "/uX1/Datasets/" {pools ""} resource scratchdisk "/uX2/Scratch/" {pools ""} } } For a better...
by mf_arts
Wed Dec 16, 2009 4:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to apply patch on DataStage
Replies: 3
Views: 3318

Taylor, These issue is applied for version 8.0.1 and you're working with 7.5.3, isn't it? take alook here: http://www-01.ibm.com/support/docview.wss?rs=0&dc=DB500&q1=ecase+116161&uid=swg1JR29243&loc=en_GB&cs=utf-8&cc=uk&lang=en I think you should contact your IBM Support ...
by mf_arts
Tue Dec 15, 2009 8:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: installation
Replies: 7
Views: 3908

Your company should and must supply the product for you, IBM spend two Billion dollars to purchae Informix/Ascential Software, what make you think you can have it for free?
by mf_arts
Tue Dec 08, 2009 8:16 am
Forum: General
Topic: RT_LOG207 error
Replies: 5
Views: 2034

RT_LOG207 error

Hi,

Check if there is any file in <ProjectDir>/RT_LOG207, it should have 3 files DATA.30, OVER.30 and .Type30, also check if your DS user have rights to read the file.

regards
by mf_arts
Thu Aug 13, 2009 6:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Find all jobs in a proj using certain hash file.
Replies: 7
Views: 2651

In DS 8.x you have a a feature called Impact analysis that would solve your probelem, however, as you are working with version 7.x you need to do some extra work. I should do the follow: 1 - Create a customized .xsl file (stylesheet) to transform the xml 2 - Export the project to xml, during the exp...