Questions tagged [dataworks]
4 questions
0
votes
1 answer
Regexp instruction in SQL
After applying function GET_JSON_OBJECT(features, '$.field') I get the values:
{10:3,300:286}
{300:86}
{300:3,50:1}
How to get the value after 300 then?
Needed result is
286
86
3

bluekit46
- 143
- 5
0
votes
1 answer
Bluemix Data Connect does not apply the filter rows for the entire dataset, just for the first 1000 rows
The operation "filter rows" does not apply for the entire dataset, just for the first 1000 rows, that is the preview. This is weird, once other operations are applied onto the entire dataset with no problem.
Is it a bug or something that just work…

Jean Pacanaro
- 28
- 4
0
votes
0 answers
License issue connecting to on premise DB2 ZoS
Even after connection is established (with secure gateway and client on my computer through which I can access the DB) and schema and tables selected in dataworks and either refine or copy selected the error below appears:
The IBM Data Server for…

zygas
- 1
0
votes
2 answers
secure gateway ACL_FILE definition?
My /etc/ibm/sgenvironment.conf file has a ACL_FILE:
# Access Control List File
# If manually modifying the following, accepted values are the absolute path to your ACL files ('none' if no file, separated by '--'…

Chris Snow
- 23,813
- 35
- 144
- 309