DSXchange

Did you check the network load at that time?

Were you able to ping to the Unix server?

Do you have an SAP logon pad installed on your desktop. If yes, then try logging through it with a normal user.

You can do a trim(yourval, '0', 'L')

First you need to define the date as a char.

Second you need to ensure that both the format and content are identical.

You can import from the source.

Simplest may be to leave it open - but this is not advisable.

Another option is to provide each user a separate project.

Otherwise you can set the permissions in your OS for this purpose.

Search this forum for more details.

If you move it to a numeric field, it will automatically do it for you.

You can use grep to remove empty lines.

head and tail do not identify or remove empty lines.

You need to include complex conditions and more development time.

You landup with performance head-ache and development back-ache.

Again, everything depends upon your business requirement, analysis and design.

To do a lookup, you need a source link and a reference link.

The datastage manual gives you step-by-step explanation and method to achieve this.

If you still have any doubt after reading and trying the same, let us know.

Note : sort -u as such performs a full row comparison.

Use the field function.

If they are in the same db, you can use a NOT IN clause.

Otherwise, you can do a lookup against the target. You can improve performance later.

Try to supply a value in sender's id.

I assume that error message is from your SMTP server and not from DataStage.