DSXchange

Yes, EBCDIC files are fixed length, I am getting this issue after reading them and loading them into teradata tables. I did try ' ' as padchar

@ Ray - I agree to your point of removing duplicates beforehand, but since it is running fine in 8.1/multiload, we are told not to do any changes execpt for that of connector :(. @ prasson - Table doesn't have duplicates, they are trying to retain the last update as per requirement. @ ramesh - we ca...

I have added the padchar variable to all the jobs right from the start of the reading of source file (which is ebcdic). Even doing so, gives me nulls as padchar. @ArndW - Yes, that was the first thing i did, the variables how '0x20' as padding character. Actually the same set of jobs run in 8.1 (whe...

Hi, I am migrating a job from 8.1 version to 8.7. This job loads data into a teradata table which is having UPI on key columns and source data is expecetd to have duplicate rows, so in 8.1, multiload stage in sequential mode is used to counter this situation, However in 8.7 using connector I am not ...

Hi Everyone, I am facing an issue while using APT_STRING_PADCHAR variable at job level. Actually at project level, the value is default '0x0', and when i set it to 0x20 at job level by adding it to job parameters, it still pads the character column values with nulls (0x0). Not sure why it is happeni...

@crystal_pup
Are you saying to change the table definition?
That field is defined as LATIN, if I use UTF-8 in terdata connector, the job simply aborts but when I change it to ASCII, then it replaces those characters with space/some other charcaters

I am also facing similar issue. Was anyone able to resolve this?

Maybe you can write a script to convert ebcdic files into ascii and then use the files in your job

I think Raftsman was pointing towards empty source(file/table) and missing target table...

why do you think its the transformer that's causing your job to stall, as you are running in vmware, from where are you pulling the source data from?

You can refer to Parallel Job Developers Guide documentation - Appendix B - Transform functions for searching the functions available in DS , Its easy to search use Ctrl+F and then search...

Hi, can anyone please describe the differences between tsort and psort operators. What i am looking for is exactly what conditions lead to insertion of psort operator and how it works.

well can you just double check the param names i can see 2 different params here
JobParam.date and JobParam.pDate

Yes you can do that, they will be implicitly parsed into the target datatypes, provided you are using transformer stage in between

what data-type u gave it to the parameter?
sometimes in 8.7 if u include a single parameter in the job properties and datatype is kept as parameter/set it will not compile, try giving string as data-type to parameter