Search found 103 matches
- Sun Mar 15, 2020 5:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: French Characters Random Conversion issue
- Replies: 2
- Views: 6526
- Sun Mar 15, 2020 5:31 pm
- Forum: General
- Topic: Connecting SQL Server DB through Windows Authentication
- Replies: 1
- Views: 12652
Connecting SQL Server DB through Windows Authentication
Hello DS gurus, I am trying to connect the SQL Server through windows authentication. I have included the below entry in the .odbc.ini file [ODBC_SQL] Driver=/home/opt/IBM/InformationServer/Server/branded_odbc/lib/VMmsss00.so Description=DataDirect SQL Server Wire Protocol driver Database=<Database_...
- Wed Feb 19, 2020 8:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: French Characters Random Conversion issue
- Replies: 2
- Views: 6526
French Characters Random Conversion issue
Hi DS Gurus, When i am loading the French Characters into Dataset. They are not being loaded properly. Some of them are loading properly and others are not. The loading of the French is random. some are good and some are not Job Design: Unstructured data --> Transformer -> Dataset Sample data: J'aim...
- Fri Jun 02, 2017 8:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Field seperator
- Replies: 6
- Views: 5441
- Thu Jun 01, 2017 3:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Field seperator
- Replies: 6
- Views: 5441
Field seperator
Hi All,
We have a file with records as below
ABC_123_DATA_RRR_TTT_OOO
ZXC_123_DATA_SSS_PPP_LLL
I want to fetch the all the data after 3rd delimiter
FOR EX: final output should be
RRR_TTT_OOO
SSS_PPP_LLL
Can you please help me on this
We have a file with records as below
ABC_123_DATA_RRR_TTT_OOO
ZXC_123_DATA_SSS_PPP_LLL
I want to fetch the all the data after 3rd delimiter
FOR EX: final output should be
RRR_TTT_OOO
SSS_PPP_LLL
Can you please help me on this
- Fri Oct 21, 2016 1:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: OSH Problem
- Replies: 5
- Views: 4861
- Fri Oct 21, 2016 8:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: OSH Problem
- Replies: 5
- Views: 4861
- Tue Oct 18, 2016 12:54 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: matches_regex should contain alphabets, numbers and Tilda
- Replies: 1
- Views: 4490
matches_regex should contain alphabets, numbers and Tilda
Hi All, I am trying to create a IA rule for value check for one of the column Rule: Field should have all three alphabets ,numbers and Special Character ~ ( tilda) otherwise the rule should fail Example : ABCD~2016187~1 ABC~2016187 the above data should be passed and below should be failed FNAL~ 123...
- Mon Feb 08, 2016 8:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential file: spaces between two characters in all fields
- Replies: 6
- Views: 4973
- Fri Feb 05, 2016 5:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential file: spaces between two characters in all fields
- Replies: 6
- Views: 4973
Hi Craig, It is showing when i read the data in sequential file and Dataset view data. Now I have loaded the file into another sequential file, when i view the file in UNIX it is showing correctly which is good. but my other issue is with the transformation, when i do substring to 10 characters it i...
- Fri Feb 05, 2016 4:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential file: spaces between two characters in all fields
- Replies: 6
- Views: 4973
- Fri Feb 05, 2016 4:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential file: spaces between two characters in all fields
- Replies: 6
- Views: 4973
Sequential file: spaces between two characters in all fields
Hi DS Gurus, I am reading a tab delimited file using a sequential file stage. When I view the file every character has a space between them. When I view the file in Excel, Textpad or UNIX the file looks good. For example: Sample source file looks like below OrderReadyForPickup_EN_QA Bounced But when...
- Thu Nov 26, 2015 11:32 am
- Forum: Site/Forum
- Topic: Premium Membership not Renewed
- Replies: 6
- Views: 24421
Premium Membership not Renewed
Hi, I have renewed the 3 year membership On November 13 2015, it is been two weeks but still it is not activated/Renewed I have sent couple of mails to the below Email ID's but there is no response from them either rick@dsxchange.net, membership.director@dsxchange.com, editor@dsxchange.net Can anyon...
- Mon Nov 23, 2015 2:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: decimal_from_string warning for same data length
- Replies: 9
- Views: 7078
- Mon Nov 23, 2015 10:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: decimal_from_string warning for same data length
- Replies: 9
- Views: 7078
Thank you Thomas .. it worked
I used the below specifications in Modify stage and the job completed successfully without warnings
I used the below specifications in Modify stage and the job completed successfully without warnings
Code: Select all
Specification = cust_num:decimal[10,0] = decimal_from_string(cust_num)
Specification = NOWARN