"15L" decodes as 15 characters wide, left justified. "15T" is the same, but breaking on word boundaries. "15R" is right justified. I have the widths in hashed file defined way higher than the expected values (there are no extra spaces as well in the data, so i am sure ...
a) Doing Trials - Since the column width seems to be the issue. I tried to increase the column width. More than the length of the data. Still keep getting the same scenario. b) Another mess up - or One interesting thing. I went into the Hashed file setting (in options, where we select dynamic type e...
I don't know the column information of the hashed file. How can I go without it. I am actually writing "select * from hashedfile;" About the formatting query SELECT @ID FMT '15L', F1 FMT '15L', F2 FMT '15L' FROM hashedfile; F1, F2 ---> Are these the column names 15L --> what does this stan...
Get the metadata correct, or use command line overrides to get the display widths sufficiently large. Code: SELECT @ID FMT '15L', F1 FMT '15L', F2 FMT '15L' FROM hashedfile; DataStage/SQL: VOC dictionary descriptors cannot be used with SQL DataStage/SQL: syntax error. Unexpected symbol. Token was &...
When I do a select on a hashed file (through unix) I don't get the each row in one line. Each field splits up and shows up in the next line. Something like this. ROW1 Fie Fie ld1 ld2 ROW2 Fie Fie ld1 ld2 instead of ROW1 Field1 Field2 ROW2 Field1 Field2 How can I avoid such scenario?
Hi there, I am wanted to obtain a pipe delimited output while reading from hashed file dssh << EOF > $filename select * from hash; >EOF looks likes this file generates a tab-delimited output. I wanted a pipe-delimited output. I can't replace tabs with pipes, as the data might contain tabs. Is there ...
Hi , I have migrated a project from DS SE 7.5.1 to DS EE 7.5.3. It worked well in the server edition but in Enterprise Edition iam getting an error while trying to view data from an ODBC Stage jobHRMI_DWH_GRADE..SrctblGrade (OpenPath failed for - /41bdsadm/Ascential/DataStage/branded_odbc ): jobHRMI...
The group, which will be handling the code transfer to production is not going to have any datastage experience + security concerns requires that everything should be automated and no source code should be availabe in production. Even I am boggled with the requirements. But I wasn't able to talk thr...
Can you specify more details. a) What are you contraints that you are using (and where, you said in file as well) b) I presume one of the files is not converted into hashed file (or is it?) c) If possible can you show miniature diagram of your design. The information in your earlier mail is not suff...
then does it make sense to use dscc to compile?? as dsjob -import , obtains only executables and executables are created from object code (after compilation) and linked libraries (I presume the answer is No, but still would like to confirm before I proceed with the design)