Search found 981 matches
- Fri Dec 16, 2011 2:27 pm
- Forum: General
- Topic: Windows Filtering Platform
- Replies: 8
- Views: 5758
- Wed Dec 14, 2011 8:52 am
- Forum: General
- Topic: Windows Filtering Platform
- Replies: 8
- Views: 5758
On similar lines, IBM says that if the User Registry in WAS was set to Federated Repository, then you can add the isadmin and wasadmin to the local repository, and hence, be able to authenticate against both, LDAP or the local internal registry. Check the link here - https://www-304.ibm.com/support/...
- Wed Apr 27, 2011 1:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Removing Duplicates : unique situation
- Replies: 13
- Views: 10897
- Wed Apr 27, 2011 1:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: suppress trailing zero
- Replies: 5
- Views: 3810
Re: suppress trailing zero
Try:
Here, "T" implies Trailing.
Code: Select all
TRIM(YourValue,"0","T")
- Wed Apr 27, 2011 1:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB Sequence and State file
- Replies: 4
- Views: 3294
If your process is the only one that will ever load the table in question then state file should be ok. If there is a chance that other applications may start entering data, then a db sequence object ... I agree with DSguru2B. We use db sequence only for those that require inserts from various regi...
- Wed Apr 27, 2011 12:13 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Unable to Import XML Table Definations
- Replies: 3
- Views: 4434
Re: Unable to Import XML Table Definations
I am getting a similar error when trying to import XML Metadata. I get the error: ActiveX component can't create object: VMDataStage.CDSXMLMDI I can, however, go to my DataStage client directory and manually bring up the XML Metadata Plugin. Can somebody help me what might I be missing? Thanks, Hi, ...
- Wed Feb 09, 2011 11:07 am
- Forum: General
- Topic: Server vs parallel jobs
- Replies: 14
- Views: 11617
- Wed Dec 15, 2010 3:47 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to insert data and capture duplicates
- Replies: 6
- Views: 4302
Concatenate all your non key columns from source into a single value and pass this value to CRC32 function. Similarly calculate CRC value from lookup/target table also. If the Key column matches and CRC values doestnt match between source and lookup then it is an updated one. I would place some kin...
- Wed Dec 15, 2010 12:43 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to convert String MMDDYYYY to Db2 date MM/DD/YYYY
- Replies: 7
- Views: 6250
Re: How to convert String MMDDYYYY to Db2 date MM/DD/YYYY
Try-svhari76 wrote:Hi
How can i convert String MMDDYYYY to Db2 date MM/DD/YYYY ?
Eg: '11302009' to be 11/30/2009
Code: Select all
Oconv(Iconv(InLink.YourDate, "DMDY[2,2,4]"), "D/MDY[2,2,4]")
- Wed Dec 15, 2010 12:32 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Need help creating optimal Static Hashed File
- Replies: 2
- Views: 3052
Re: Need help creating optimal Static Hashed File
BTW, I have left the Separation to default of 1.
- Wed Dec 15, 2010 12:29 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Day of year
- Replies: 2
- Views: 2459
Re: Day of year
I'm trying to convert a date to the format YYddd (day of year). Is there any way to do this inside a transformer? I've been trying different things for a couple of days and can't get anything to work. Assuming your input date is in the format YYYY-MM-DD, try this- Oconv(Iconv(InLink.YourDate,"...
- Wed Dec 15, 2010 9:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Need help creating optimal Static Hashed File
- Replies: 2
- Views: 3052
Need help creating optimal Static Hashed File
I need to create a Static Hashed File that contains the following columns- Total number of rows = 10,000,000 (10 million) SomeDateAndTime KEY, TIMESTAMP(19) eg. 2010-05-12 09:30:45 FirstAmount Non-Key, INTEGER(7) eg. 1234567 SecondAmount Non-Key, INTEGER(7) eg. 1234567 I am using the HFC calculator ...
- Thu Nov 18, 2010 1:07 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Improving Job performance
- Replies: 16
- Views: 9211
- Fri Sep 10, 2010 2:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: duplicate and non duplicate data
- Replies: 4
- Views: 3098
Re: duplicate and non duplicate data
Hi, A sequential file has 8 records with one column, below are the values in the column separated by space, 1 1 2 2 3 4 5 6 In a parallel job after reading the sequential file 2 more sequential files should be created, one with duplicate records and the other without duplicates. File 1 records sepa...
- Tue Jul 20, 2010 1:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: All different commads to import datastage jobs.
- Replies: 3
- Views: 5761
Re: All different commads to import datastage jobs.
I use the dscmdexport.exe command wrapped in a batch script that is scheduled from Windows client (that contains DS client) to create the dsx file. It creates a single dsx file for a project and contains jobs, routines, table defintions, executables etc. Whenever I want to split them into individua...