DSXchange

Im answering to my own post, The problem seemed in PX 7.5.1 itself. The fields with the CHAR datatype and that had string values got padded with SPACES. Ironically, number values din't get pad with SPACES in the same CHAR field type. Once, I changed all the datatypes to VARCHAR I tweaked the problem...

I earlier posted a Q with how to get rid of trailing weird characters. The issue was solved after getting a response here on DSX asking to change settings in the DS Admin, changing the variable APT_STRING_PADCHAR to space. Thanks gh_amitava. Now after the change Im getting trailing spaces that I can...

In the "format" properties of the sequential file, choose filed defaults as
delimiter = comma , quote = double.
That should do it.

i have just tried varchar and that dint seemed to tweak either. When I view the file on the AIX box the string columns don't have any 'weird' trailing characters. When I ftp it over(ASCII mode) they seem to get trailed. They are visible only from wordpad and although notepad seems place blanks in th...

"I have already used the function CompactWhiteSpace,Trim, TrimB,StripWhiteSpace to get rid of these trailing characters. "
I have verified the file again. They don't seem to exist when I view them on our AIX box. When I ftp over in ASCII format they get trailed in.
Any inputs??
Thanks!

In the final stage of my job where the target is a sequential file(*.dat). Char SQL Type columns are getting trailed by weird characters that look like small boxes which are highly unprintable. I can view these in Wordpad but not in textpad. I have already used the function CompactWhiteSpace,Trim, T...

I am creating multiple lookupfilesets in a job from DB2(source). I currently have transformers between source(Db2) and target(lkupfilesets). Since I am not performing any transformations, rather making a copy. I am thinking a copy stage in between would be much preferred to make the job run faster. ...

Arnd,
Do you think it could be a compiler related problem?
If all configs are fine and if the user earlier ran it successfully earlier, then I guess it needs some kind of patch management with Ascential.

Check all default configuration settings. Check installation manual for all default settings.
Is your default.apt setting file been configured?

What should I use for the Substring function which doesnt seem to exist in 7.5 . Thanks!

Why cant view data on the lookup file sets? I understand that the data that comes in resides in difft files on the server based on node config. Is there a way to view data to click view., or would that be a future feature of DS.
Thanks
DSIF

Lookup Filesets Im trying to use Lookupfile sets with a Lookup Stage. There seems to be a problem somewhere that I can't understand. Lets assume we have a table - EMP with the fields : EMPNO DEPTNO ENAME SAL MGR We have a Lookupfileset DEPT with the fields : DEPTNO DEPT Say, the Lookupfile Set was c...