Doubt regarding the size

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ds

Doubt regarding the size

Post by ds »

What is the number of bytes taken by the varchar data type while t is storing?
And if we want to convert it to date which takes 4 bytes what is to be done
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The record schema will tell you that. The prefix is the number of bytes in the number that describes the length.

Convert to date using StringToDate() function. For this to work your string must contain a valid date according to the date format string you specify, or according to the project's default date format string if you do not specify one.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ds

Post by ds »

ray.wurlod wrote:The record schema will tell you that. The prefix is the number of bytes in the number that describes the length.

Convert to date using StringToDate() function. For this to work your string must c ...



I cant view the full content.. Plz post it seperately
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

For less than 30c (approximately Rs12) per day you can purchase premium membership which, among other things, will allow you to read the entire post. Premium membership is one of the ways that the hosting and bandwidth costs needed to keep DSXchange alive are covered. On that basis I can not accede to your request.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply