Search found 406 matches

by JRodriguez
Tue Jul 14, 2009 7:35 am
Forum: IBM QualityStage
Topic: Street number is geting identified as house number suffix
Replies: 6
Views: 4966

Yes, you can edit the classification table for this entry and assign any other class instead of the default "C" (Cardinal Number)...but that will bring other issues when "Three" really mean "3"

I would stay put with the Input pattern overrides
by JRodriguez
Mon Jul 13, 2009 2:01 pm
Forum: IBM QualityStage
Topic: Pattern Action File Code Validation
Replies: 6
Views: 5939

Well ... you are in the right track ... Take a look at variable temp, is never been cleared , so if the repeating token one [1] that you are using in all your actions you really mean [1], [2], [3] and [4], then you will have: The content of {exterior} = [1] concatenated with [2] {Interior} = [1], [2...
by JRodriguez
Thu Jul 09, 2009 9:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Ability to view logs in Director but not start/stop jobs?
Replies: 10
Views: 7098

Sorry, I wrote it backward, here is how should be: If RTLogging=1 and ORLogging=0 the logs will be available ONLY in Director. If RTLogging=0 and ORLogging=1 in DS Director and the Web Console..... for any job that run after you put this setting in DSParam. Old logs will still be available in the We...
by JRodriguez
Thu Jul 09, 2009 9:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: sending data to MQ
Replies: 2
Views: 913

Take a look at the length in theMQ input column definition ... if the data type is char and the length of your input XML content is greater then it will be truncate it
by JRodriguez
Thu Jul 09, 2009 9:03 am
Forum: IBM QualityStage
Topic: Ruleset for standardinzing Mexican Ta Payer ID/ IFE/ etc
Replies: 7
Views: 3549

DvStand, Definitely you can develop a Rule Set to accomplish your requirement using Pattern Action Language. It work for any complex or single string. You would like to use operand substring, length, template -PICT allows test special format like your) ... among others. There are some example of how...
by JRodriguez
Thu Jul 09, 2009 8:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Ability to view logs in Director but not start/stop jobs?
Replies: 10
Views: 7098

If RTLogging=1 and ORLogging=0 the logs will be available in both Director and via the Web Console. If RTLogging=0 and ORLogging=1 only via DS Director ..... In our case we have all environment set equal, RTLogging=1 ORLogging=0, so we need to see logs in Director. main reason for this is that we wa...
by JRodriguez
Wed Jul 08, 2009 5:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Ability to view logs in Director but not start/stop jobs?
Replies: 10
Views: 7098

In IIS 8.1 world you can obtain a lot of those reporting/auditing in the Web Console for any activity that has been completed in any component of the suite ..... You can customize a report or a log view that can be saved in the metadata repository and accessed only by authorized users Please note th...
by JRodriguez
Wed Jul 08, 2009 1:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Mailing file contents
Replies: 6
Views: 3703

The body of the email notification activity don't allow parameters :( But if you would like to used a server job then try below using DSSendMailTester utility: The job design looks like this : Folder Stage --> Transformer --->Seq File Read your file with a folder Stage, the content of the file will ...
by JRodriguez
Wed Jul 08, 2009 8:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: UtilityRunJob error with DataStage 8.1
Replies: 9
Views: 9433

Marcelo, How about using a sequence and two jobs. The first one, a server job extracts the value using your SQL and place it in the job's user status area. The second job activity (obOD0040B) will have the previous job user status available to be pass as a parameter value Search the forum for other ...
by JRodriguez
Tue Jul 07, 2009 2:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: UtilityRunJob error with DataStage 8.1
Replies: 9
Views: 9433

Marcelo, I would set the basic transfomer to execute sequentially or used a single node config file...or you will be executing the job multiple time as many as your $APT_CONFIG_FILE, If you really need to execute the 'child' dependent job multiple times then make it multiple instance ... Have fun ...
by JRodriguez
Tue Jul 07, 2009 10:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Metadata repository
Replies: 3
Views: 1856

Previous to 8.1 the tool used Universe tables (hashed files) to host all objects related to projects. The Universe database was not optional ... you can't replace with any other

In 8.1 the metadata repository must be hosted in a RDBMS, options are DB2, SQL Server and Oracle
by JRodriguez
Fri Jul 03, 2009 7:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Slowly Changing Dimension stage : Quick explaination
Replies: 3
Views: 1702

Did you have the DataStage IBM Red book? If not do a search, is free, and will answer most of your questions

"IBM InfoSphere DataStage Data Flow and Job Design"
by JRodriguez
Fri Jul 03, 2009 7:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: MQ Series Stage
Replies: 13
Views: 4575

In IIS 8.x the Plug-In stage is available for server and parallel jobs. The new Connector stage is only available for Parallel jobs So if you are developing server jobs then your only option is the Plug-in .... regardless the connection mode I recall a couple of presentation from IOD 2008 that speci...
by JRodriguez
Thu Jul 02, 2009 7:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: OCI PLUG IN
Replies: 9
Views: 2421

In Designer

View-->Customize Palette -->Stage Type -->Parallel --> Database

Here you can add the stage to your palette
by JRodriguez
Thu Jul 02, 2009 7:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: MQ Series Stage
Replies: 13
Views: 4575

For Server jobs only the old MQ stage ( Plug-in ) is available. The new MQ connector stage is only available for Parallel jobs ...