How can I store a delimited string as a variable length vector for vector matching?
Example source string (delimited by pipes)
'2'|'4'|'22'|'22'|'19'|'8'
Search found 31 matches
- Mon Jan 06, 2020 7:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Delimited String to Variable Length Vector
- Replies: 0
- Views: 3693
- Tue Apr 30, 2019 12:21 pm
- Forum: General
- Topic: Modified parameter value wont refresh in DataStage client
- Replies: 3
- Views: 3684
Hi lkevin1210, I have experienced a similar (if not the same) issue. Making a change to a parameter set structure such as changing default values and adding or removing parameters do not reflect in the job until the designer is closed and relaunched. This happened a few months ago and from memory I ...
- Tue Apr 30, 2019 12:11 pm
- Forum: IBM QualityStage
- Topic: Locking QS Lookup Tables
- Replies: 3
- Views: 11378
- Mon Apr 29, 2019 7:25 am
- Forum: IBM QualityStage
- Topic: Locking QS Lookup Tables
- Replies: 3
- Views: 11378
Locking QS Lookup Tables
Hi, I have a lookup table define that is being used for a number of QS Rule Sets that I want to remain static. Is it possible to lock these lookup tables in much the same way that the provided Rule Sets have lookup tables are only available to open in view mode? For example the provided AUFIRSTN.TBL...
- Sun Feb 10, 2019 10:40 am
- Forum:
- Topic: Cataloging Hadoop Metadata
- Replies: 2
- Views: 3102
- Thu Feb 07, 2019 10:49 am
- Forum:
- Topic: Cataloging Hadoop Metadata
- Replies: 2
- Views: 3102
Cataloging Hadoop Metadata
Hi, I was hoping that someone has had experience cataloging Hadoop assets in IGC and provide feedback on how easy/painful the process was. Currently I am working at a site where they decided to install the minimum to use DataStage and QualityStage, even though the client is entitled to install the e...
- Mon Nov 19, 2018 1:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Relationship between Nodes and Partitions...
- Replies: 6
- Views: 4384
If the data isn't suited to partitions what is the point of using a checksum for partitioning? For example if you want to partition on say a gender code which potentially only has two distinct values and you checksum on the gender code you will still only have two distinct values produced from the c...
- Thu Nov 15, 2018 8:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parse JSON using a Schema
- Replies: 4
- Views: 5271
- Mon Nov 12, 2018 7:30 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: How can I backup Information Analyzer assets?
- Replies: 2
- Views: 12144
Have you considered the istool command to manage your IA assets?
https://www.ibm.com/support/knowledgece ... mmand.html
Cheers,
jneasy
https://www.ibm.com/support/knowledgece ... mmand.html
Cheers,
jneasy
- Mon Nov 05, 2018 2:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parse JSON using a Schema
- Replies: 4
- Views: 5271
Parse JSON using a Schema
Hi, I have been attempting to parse large JSON files (+200MB) that are provided on a daily basis using the schema provided. I do know that in the Hierarchical stage the assembly editor can infer the schema by just importing the JSON data file,I have been able to parse a file based on this approach. ...
- Mon Nov 05, 2018 1:37 pm
- Forum: General
- Topic: Clear DataStage Director logs ..
- Replies: 1
- Views: 2552
- Tue Nov 01, 2016 9:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Modify column on a quoted column name
- Replies: 3
- Views: 3735
- Tue Oct 25, 2016 8:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Modify column on a quoted column name
- Replies: 3
- Views: 3735
Modify column on a quoted column name
Hi, I am trying to rename a field using the following MODIFY spec. "MODE":string[50]=string_from_ustring(MODE); But I get this error "Error parsing modify adapter" I have a generic job using RCP to SELECT * from a DB2 then load into Teradata DB2 --> Modify --> Teradata The Terada...
- Thu Jun 09, 2016 8:06 pm
- Forum: IBM QualityStage
- Topic: Pattern Variables
- Replies: 1
- Views: 12821
Pattern Variables
Hi, Does anybody know if in the Quality Stage PAT file if a Pattern can be generated from a variable? essentially I want to do the following; [ temp ! = "" ] PATTERN temp --> temp_pat I know that PATTERN only works on active tokens but the problem is I have already retyped them to 0. Any i...
- Thu Jun 09, 2016 7:56 pm
- Forum: General
- Topic: RT_STATUSnn Record Schema
- Replies: 4
- Views: 3811