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…
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