DSXchange

Ray, I guess I wasn't thinking hard. Thanks for the reminder. I parsed it inside the job by first padding the incoming varchar string with 0's for the missing bytes. Appreciate it! Craig, You might be right. I need to check on how the FTP process mutilated the file. Will get back. Thanks, Whale.

Hi all, I'm trying to read a supposedly fixed width (400 bytes) file consisting of 5 million records. But about 10,000 records in the file have the last field data (5 bytes) missing resulting in 395 bytes instead of 400 bytes. All records have the record de-limiter as the UNIX newline. For example, ...

Hi all,

Any inputs on how the table load works in DB2 Enterprise stage with the TRUNCATE option are greatly appreciated.

How does the DB2 EE stage truncate the table under the covers?

Regards,

Whale.

Thanks, Ken!

Appreciate it.

Whale.

Hi all,

A generalised question. If the DB2 tables in our Datawarehouse environment are range partitioned. How will this change affect DataStage?

Appreciate your inputs!!!

Whale.

I think a 'workaround' is what you do to get a process to work while reporting the bug to support and waiting for a fix. Several times in the past I have had to protect calls to APIs that were not checking for bad arguments, whilst also reporting the API crashes to the vendor. Totally concur with t...

deanwalker wrote:Same answer:
You can't use an environment variable 'there'.
The workaround is to use GetEnvironment("envvarname")

Hi Dean,

Thank you. But, I'm not looking for a workaround. I just want to know if this is a bug in 8.x.

Regards,
Whale.

Craig,

I'm using 8.x and it blows up in 8.x. If you are on 7.x, can you confirm if it blows up on 7.x as well?

Regards,
Whale.

Thanks Craig!!

Isn't it supposed to work in the transformer derivation? Was this the same behavior in 7.x as well or just a bug in 8.x?

Regards,
Whale.

Hi all,

I'm trying to use an Environment variable (project level params) in the column derivation of the transformer and the job wont compile. Anybody encountered this?

Regards,
Whale.

Hi all,

Does anybody know or guide me on how to delete the first n bytes and last n bytes from a binary EBCDIC file?

Any help will be greatly appreciated!!

Regards,
Whale.

Ray,

Sorry for the delayed reply. Yes! I'm looking for the 8-bit representation as you pointed out. Unfortunately, nothing out of the box in PX to derive a binary representation. May be, a custom routine!!

Appreciate your inputs!!!

Best Regards,

Whale.

Ray, Thanks much. I was able to use the first one "Seq" but it does not give the 8-bits, it just gives the decimal equivalent. Say, if the hexvalue of the Char(1) field is "1a" then it gives me 26. Not a 8-bit representation. But thanks for sharing that function. Did you try usin...

Hi all,

If I have a incoming field as Char(1). How can I get the binary representation of the value in the Char(1) field?

Since input field is 1- byte. I would be expecting a 8-bit binary value.

Any ideas appreciated...

Thanks,

Whale.

Thank you, ArndW! Seems like the table is not partitioned. Appreciate your inputs.

Whale.