DSXchange

Padchar = SPACE

The job design is like this: SEQUENTIAL FILE - BASIC TRANSFORMER - SEQUENTIAL FILE I am Trimming, changing the datatypes from varchar to char, and forcing 2 decimal(20) values to char(17) using Right(Trim(IN.COL,".","A"),17) Thats it ... there nothing more to the job. you can see...

Thanks for the replies guys ... sorry i'm late to catch up, The "space characters" which are padding the data show up as "#" in SAP BW environment. 20 14 ctlT DC4 | 84 54 T is the value padding the data, Its a space but shows up as "#" in SAP. When i try to view the fil...

0506110000 0000905413TN200605120620000000 0000905413TN200605140356380000 0000905413TN200605150568250000 0000905413TN200605210306880000 0000915113 ZP200608130546660000 0000915113ZP200608140291640000 0000915113ZP2006081806 04450000 0000915113ZP200608210647340000 0000905413TN200605120241960000 00009054...

PX JOB

But I am using a server transformer in the job.... We dont have the parallel compiler

HI, I am creating a fixed width file as a final target to my job. DS fills the empty space with blank values which are not spaces. This file when we try to load to SAP those blanks show as ###. I have tried viewing the file in HEX EDITOR and found that "20" is filling in the spaces( THE VA...

@DSguru

So my job will look like


seq file > modify > ...rest of the job....>>>

Would that solve my problem?

When i specify a default value in the table definition , I dont get the **** anymore ... Cant I insert blank space in "Timestamp" field?

I do not use a parallel transformer in my jobs , I use a basic transformer in my parallel jobs too. Where can I specify type conversions

No type conversion in the job. I am performing two joins on the data but no transformations and type conversions.



SEQ file Seqfile

> join1 > Join2 > Output Seq File
Seq File

Hi, I have a job where I get blank data from the source for a column with "Timestamp" datatype in a seq file. The source is from a server job. When i view the data in parallel it shows blank columns but when I write the data in a seq file or a dataset.... The data shows as "*******&qu...

The script name is "PMCSExtractEPBWhlseOrders", its a sql script. I am specifying the script in a execute command stage in a sequence. Is this the way I am supposed to do it?? I get a error saying SP2-0640: Not connected , when i do it ... does this mean i dont have the permission to execu...

I dont know if NLS ia enabled or not but, ... there are no characters other than alphabets and digits in the column thats missing

I have the same problem with another file ... its also a "|" delimited file coming from a sql script. I can see data from all the columns except one ... The column shows up blank, there is data present in the column for sure ... The datatype is varchar... I tried changing it to decimal ( f...

Thanks for the response guys... In my case i'm comparing the counts in a job , ... INPUTROW COUNT = OUTPUT ROWCOUNT (this is the constraint), if they are equal then the job should run. If not it should fail. This job will be in a sequence, so even if the job fails after processing all the rows ... a...