DSXchange

Hi Ray,

I am facing the same issue .

Can we expect better performance if i create the same format file using Sequential File stage?

Sequential File stage is better than CFF stage? Or CFF stage is the best?

Please suggest any other alternatives we have...Thanks

Hi Eric,

I am trying to write to the file (Target) , suggest me ..thanks

All specifications should be in CHARACTERS. So the number of bytes per character is not an issue. Do your data contain any double-width Chinese characters (that is, characters that take up two display positions, such as " double happy ")? If so that might be affecting your file format. Hi...

Hello, I am creating the target file as fixed width (ASCII) with Sequential file stage.I have one field where i get Chinese chars , in any record when i have Chinese chars in that filed then it is moving the value of next filed to right , so record format is going wrong. I am using UTF-8 in the job ...

Thank you Craig.
That is what I have been doing (re compiling ) but would like to know if we have any alternatives to keep most recent instance and purge rest.

Thanks.

We have many multi instance jobs and each time we run each job will use unique invocation id and we do not have a mechanism to clean up all these instances. With all these instances, we are able to open director.

Is there any way to clean up all older instances?

Thanks in advance.

Thanks Ray. I am trying to build a checkpoint restart job and my DB2 connection is timing out. So I thought of sending every 10,000th row to DB2 table so that DB connection does not time out. So, is there any way to identify every 1000th row in every partition in a transformer.

-Anu.

Is there a way to get every Nth row? I mean I need to tap every 100th record in every partition.

Thanks in advance.

Thanks,
Anu.

Yes, i am receiving files as sourcefile.bin and sourcefile.ebc

Thanks for your reply

Is it possible to read .ebc or .bin files with CFF Stage ?

Hi

I will be receiving EBCDIC file in BINARY format and multiple record types (Header,Rec1,Rec2,Rec3,Rec4 and Trailer).

So i have question what are all file extensions (Example : .dat, txt ...) the Complex Flat File Stage will accept to read.

Please help me ...

ray.wurlod wrote:Specify a larger scale value than 3.

Thanks Ray.

I have specified Decimal(31,10). Even though it is getting rounded.

I have source field geocode and value as below.. source - Geocode = 40.145000|-84.24860 I need to parse above value into Latitude & Longitude Latitude = 40.145 Longitude = -84.2486 I am using below transformations Latitude = StringToDecimal(Field(geocode,"|",1)) Longitude = StringToDec...

subramanya

Did you find a solution? We have a requirement to convert UTC datatime into EST and load into a DB2 table.

It would great if you can share the solution.

Thanks in advance.

ray.wurlod wrote:Probably a function like TimestampFromSecondsSince() using 3600 * hours as the offset. ...

Ray-

How to pass the number of hours to offset since it will change with day light saving.