DSXchange

Yes, It hits database based on the block specified. In my view flat file gives much performance compare to DB sequence Since DB sequence will have I/O operations with DB server if DB is landed in other host then there will be network traffic. As suggested by Sura, Security wise chances for corruption.

Pl. find the revised code which helps to select folder during runtime. Sub GetAttachments() Dim ns As NameSpace Dim Inbox As MAPIFolder Dim Item As Object Dim Atmt As Attachment Dim FileName As String Dim i As Integer On Error GoTo GetAttachments_err Set Inbox = Outlook.GetNamespace("MAPI"...

Hi,

I am generating sample data through Row Generator of 1000 records. But some records have null values. I tried to change nullable propety at Row Generator and Sequential file. But no luck.

Just wondering whether we could generate records without nulls through Row Generator.

As Sreeni said,

Field(Column_Name,"_",1)

It will solve the issue...

Issue was fixed by Admin. Client version was missing out FIX Pack-1, When Fix Pack added then issue resolved.

Cheers...

Apply Index function it will give position of the "-" then apply substring function.

We are not able to compile and run it. We have taken up this issue to Admin level for further action. Will come back with updates.

Thanks for your thoughts...

When i type the function manually it is showing in red color. i.e function not available.

Hi,

Not able to find NextSurrogateKey() function at Datastage 8.5.

But where as we could able to find NextSurrogateKey() function at Datastage 8.1

Transformer --> Functions --> Utility --> NextSurrogateKey()

Please suggest.

Why not one of the tools built into Windows / Office like VBA, for instance? Yep, I am in half way. Find the VBA code which helps to save attachments into Hard drive. Sub GetAttachments() Dim ns As NameSpace Dim Inbox As MAPIFolder Dim Item As Object Dim Atmt As Attachment Dim FileName As String Di...

Hi,

Let me explain my requirement as follows.

Need to access microsoft outlook if any mails contains attachment we need to save those attachment in a particular folder.

Do a run in 8.5 and 8.1 then compare the results using any comparision utility for accuracy.

Define SupplyType1,SupplyType2,SupplyType3,SupplyType4,SupplyType5 columns with derivation as ATS ,EIP ,OIP ,RIP ,TROUBLE for respective Quantities. Pviot the data based on the below. SupplyType - SupplyType1,SupplyType2,SupplyType3,SupplyType4,SupplyType5 Quantity - Quantity1,Quantity2,Quantity3,Qu...

For Numeric Key Column Modules is best partition and for non numeric columns Hash is best partition.

If you want to see what partition Datastage selects when you select Partition as Auto then enable Dump score Environment variable to trace the Partition method.

I agree... I made it as Key to remove duplicates...