Yeah - I was using the name of the file returned by /home_content end point to then create a load job. However, it seems that DB2 on Cloud persists the original filename.
So e.g. if you were uploading a file called People.csv, you'd make your call to /home_content and get a response with a name like "xxxx_xxxx_xx_People.csv". When then creating a load job, you just need to use People.csv as the filename rather than "xxxx_xxxx_xx_People.csv".
Vandan
------------------------------
Vandan Parmar
------------------------------
Original Message:
Sent: Thu October 07, 2021 10:38 AM
From: Nestor Brito
Subject: ERROR: WHILE LOADING DATA IN CLAOUD DATABASE
Hi - did you manage to resolve this issue? I'm currently having the same error.?
I appreciated any help!
------------------------------
Nestor Brito
Original Message:
Sent: Tue July 20, 2021 11:03 PM
From: Vijayalakshmi Arjunan
Subject: ERROR: WHILE LOADING DATA IN CLAOUD DATABASE
Receiving the an error while trying to load data on previously created table on DB2 cloud lite version.
Below is the error information:
An unexpected token ""S3::s3.private.us.cloud-object-storage.appdomain.clo" was found following "FROM". Expected tokens may include: "<filename>".. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.27.25
Number of occurrences: 1
Any help appreciated!
------------------------------
Vijayalakshmi Arjunan
------------------------------