DSXchange

Dear All,

Is there any way to produce the output file as PDF file format??? Whenever I tried to output as PDF, there is no error in Datastage but I cannot open that file as PDF later.
Is there any idea please???



Thank you,

Yes. Will do. Thank you for your advise.

chulett wrote:I believe it should, no-one has contradicted that yet but you really should be reporting / confirming this with your official support provider - both for your current version and any future versions. Horse's mouth and all that.

So, folder stage files should include all the rows for that key. Right? If this is a bug in this 7.5 version, how about in version 8 as I have plan to upgrade our existing version to version 8. I never have this BASIC routine but I will try it :( Or do we have any way to use the FileName that I read...

Really?Do you mean, the output file should have all the records for that specific order_id?
But my output order files include only one last record for that specific order_id
Yes. I sorted by Order_id.
Is there any idea please???



Thank you so much for your time,

I have already tried with folder stage but it could solve only 50% of my requirement. Using Folder stage, files could be created according to Order_id but the problem is the generated file can keep only the last rows of the specific order_id :( Actually there should hav more than one rows in the fil...

Nope. Mine is 7.5 Window version :( May I know how to create unique list of value? Do you think it can be solved as my requirement include duplicate order-id with diff sku? Thank you so much for your time, Do you have PX installed ? Reason for this question is that I can give you easy solutions in U...

Dear Sainath, Yes. I am so sorry that I gave poor example and made misunderstanding :( Yes. I also want to split the files according to Order_id but I don't know how to split the rows by grouping order_id such as 001,10001,100,10,10 001,10002,100,10,10 001,10003,100,20,20 I want all the above 3 rows...

Dear ArndW and Saint, Yeah I really want to use it but my actual rows will be as below. Order_id, SKU, VndNo,Qty, Price... 001,10001,100,10,10 001,10002,100,10,10 001,10003,100,20,20 002,10001,101,12,12 . . . Then I want to send order no 001 to respective VndNo 100's email. So I want to check the ne...

Dear Ray,

Ok. I will find it although I do not know what is STAGECOM.ARR.
Is it possible to explain little bit about STAGECOM.ARR???
I am so sorry for my poor knowledge:(


Thank you so much for your time,
ICE

Dear All, Is there any way to overwrite the parameter with row values? For example: Job parameter vndemail=123@abc.com row value -> vndA,vndAemail@123.com vndB,vndBemail@456.com vndC,vndCemail@123.com . . . I would like to overwrite the value of vndemail=123@abc.com with vndAemail@123.com when readi...

Dear Ray, I use job parameter to pass NULL value. I set the parameter in transformer stage to update. I use ODBC stage to update SQL server. Btw, I also tested using @NULL variable but it didn't work. Job always reject the row giving the foreign key violation error. Thank you for ur time, ICE How ar...

Dear All, I have one DS job which I use to update one SQL server table column that is a foreign key of that table and also a nullable field. I can update with other value successfully if its value is in the primary table but I cannot update with NULL value although it is Nullable using my DS job. I ...

Dear Sainath.Srinivasan, 1.Yes. It is same user. 2.The file has no restriction to copy. That's why I could copy when I run that bat file manually. Right? 3.Yes. It is permanent. I always map to that drive. Whenever I restart the server, I remap it. Is there any other idea please??? Thank you for you...

Dear Chulett, In datastage, I did not change anything before I get this error. I just map to the drive once I got the same error before and then it works fine. But now the same error came up again. Please find the error msg below. Log said only "Access is denied." Batch::Emppro..BeforeJob ...

Dear All, I have one DSJ job which has to copy the source file from AS400 server to Datastage server by using DOS bat file at Before-Job Subroutine. There is AS400 map drive at Datastage server. Actually this Job was run smoothly since 2007 without map drive to copy the source file. But last year I ...