DSXchange

"How you want it look in your sequential file " what the best practice?

What does it mean by at global level? How should i set it?


Thanks

sequential file-->Format-->Field defaults-->Null field value = ''

o/p:

Still i am ending up with NULL in some column values?

Did i miss any thing?

How we can check null for individual columns

When we are writing data into sequential file

Do we need to check all columns for Null value?

IF ISNULL(DSLink.xxxx) THEN '' ELSE DSLink.xxxx

When i view the sequential data i am seeing NULL in some column value?


Thanks in advance

ray.wurlod wrote:No. The leading zeroes are added when the value is displayed or converted to string to show that precision and scale are being handled correctly. The value is correct. ...

Thanks

Do we need to change the sql_type in parallel?

COLUMN NAME: ID
SQL_TYPE: DECIMAL
LENGTH: 14
DISPLAY: 17

O/P 555

PARALLEL:

COLUMN NAME: ID
SQL_TYPE: DECIMAL
LENGTH: 14

O/P
000000000000555.

kumar_s wrote:You can give two single qoutes. As ''. ...

I did default stage variable to svNew = '' svOld = ''. but still no change.

In your early post you did mentioned about svSerialNp = 0, do want me to create a new stage variable. i was not able read the entire message

Thanks

chulett wrote:I have no idea what you are trying to add to this conversation in your post, can you try again please?

I made a change to my pervious posting

I am generating a sequential number by using KeyMgtGetNextValueConcurrent for example col1 col2 456318#16#1 6578 456318#16#2 6580 456318#16#3 6582 784654#19#1 6584 784654#19#2 6586 784654#19#3 6588 814544#20#3 6590 826545#21#3 6592 835646#22#3 6594 I want the same sequential number to be assigned f...

How can we generate same value in col2 for one family of records.

the current job is using KeyMgtGetNextValueConcurrent to generate col2

col1 col2
456318#16#1 6578
456318#16#2 6580
456318#16#3 6582


col1 col2
784654#19#1 6598
784654#19#2 6600
784654#19#3 6602

Any idea

I have to create a list with "each job sequencer name,Status, started, ontime,last ran, on date"

Thanks

chulett wrote:Not even going to guess exactly what you mean by "list of job sequencer", can you try rephrasing the question, please?

I have to create a list with "each job sequencer name,Status, started, ontime,last ran, on date"

Thanks

swades,

Do we have a similar command to reset dsadm password.

Thanks

How to change it at UNIX level?

Do you mean this way

login as root then

# passwd username
Type in a new password
Type in the new password again.

Thanks

8.1 version on linux

I forgot the password for dsadm, how can we reset password for dsadm.

Thanks

Can we install "IBM infosphere datastage" on windows 7 operating system

Thanks