Hi. I am executing `tbuild` with a job script that makes use of templates to delete from a staging table and load data into that table from a delimited text file. When I execute this command logged in as my user it succeeds. However, when I execute it logged in as someone else, it fails with:
The error message is clear enough: logged on as the other user, tbuild does not have permission to view a schema file. But why? Isn't tbuild creating the file and reading it in the same session?
Here is the command I am using:
tbuild -f /home/myusername/Delete_Table_Then_Load_File.txt -u TargetTdpId = 'foo', TargetUserName = 'bar', TargetUserPassword = 'baz', TargetTable = 'MY_STG_SCHEMA.MY_STG_TABLE', FileName = '/home/myusername/my_data_file.dat', DCPFileList = 'N', Format = 'Delimited', LogTable = 'MY_STG_SCHEMA.MY_STG_TABLE_L', DeleterLogTable = 'MY_STG_SCHEMA.MY_STG_TABLE_L', SourceFormat = 'Delimited', DCPSkipRows = 1, DCPSkipRowsEveryFile = 'Y', DCPOpenMode = 'Read', DCPTextDelimiter = '|', DCPQuotedData = 'Optional', DCPOpenQuoteMark = '"', DCPCloseQuoteMark = '"', LoadInstances = 1, DCPInstances = 1 TPT_20151130_153443
Here is /home/myusername/Delete_Table_Then_Load_File.txt: