DSXchange

U29ycnkgUmF5LiAgSSBkaXNhZ3JlZS4gQSBVTklPTiBpcyB0aGUgY29uY2F0ZW5hdGlvbiBvZiB0 d28gdGFibGVzLCB0aGF0IGhhdmUgdGhlIHNhbWUgY29sdW1ucy4gIEl0IGluaGVyZW50bHkgaGFz IG5vdGhpbmcgdG8gZG8gd2l0aCBkdXBsaWNhdGUgcm93cywgYWx0aG91Z2ggdGhpcyBwcm9jZXNz IG1heSBjcmVhdGUgZHVwbGljYXRlIHdpdGhpbiB0aGUgcmVzdWx0YW50IHRhYmxlLg0KD...

I am getting an error and don't know how to research it. What is status=13, when opening flat files? Deptree..siDeptree.lin: DSD.SEQOpen Failed to open baseroll.csv in directory \\Phl-file-04\Is\MES-QDW STATUS = 13. I can open this file using MS/Explorer, but I cannot view the file from Designer/Job...

Sequences are not part of PL/SQL. They are independently created objects in the Oracle database. You invoke them from DataStage the same way you invoke them anywhere else, by referring to them in an SQL statement. You may need to switch from generated to user-defined SQL to do this. For example, you...

have you read your manual yet indumathi venketapathi wrote: > how to call oracle pl/sql sequences in data stage. > > _________________________________________________________________ > Stay informed on Election 2004 and the race to Super Tuesday. > http://special.msn.com/msn/election2004.armx > > __...

R3VpbGxsZXJtbywNCg0KCWFuZCBmcm9tIHdoZXJlIGRvIHlvdSBjYWxsIHlvdXIgcm91dGluZT8N CglUa3MsDQoJQWxleA0KDQoJCS0tLS0tTWVuc2FnZW0gb3JpZ2luYWwtLS0tLSANCgkJRGU6IGdi YXJza3lAb3NkZS5jb20uYXIgW21haWx0bzpnYmFyc2t5QG9zZGUuY29tLmFyXSANCgkJRW52aWFk YTogdGVyIDE3LzAyLzIwMDQgMTU6MzggDQoJCVBhcmE6IERhdGFTdGFnZSBVc2VycyBEa...

hi In an OCI stage, go to output tab in that you will find user-defined sql. Write SQL in the Before tab. Ex. select Nextval. from dual. mahesh mgotur_mca@yahoo.com --- indumathi venketapathi wrote: > how to call oracle pl/sql sequences in data stage. > > ____________________________________________...

how to call oracle pl/sql sequences in data stage. _________________________________________________________________ Stay informed on Election 2004 and the race to Super Tuesday. http://special.msn.com/msn/election2004.armx _______________________________________________ datastage-users mailing list...

Thanks, John! This sounds like what i'm probably looking for. I'm on Windows, not Unix, but the same idea should work. This is kind of what i was hoping for, but not sure how to read a text (parameter) file in and use it as "the parameter" for that specific job. Is there an easy way to do ...

Thanks for the quick response, Julie! This sounds helpful for 1 job, but i actually have MANY jobs. So i was actually looking for something more "global". If i have to change the parameters in every job, it becomes quite a monthly headache. ;> Eric ---------- "History must repeat itse...

VmFzY28sDQpJIHRoaW5rIGEgcmVmZXJlbmNlIGxpbmsgd29uwrR0IHdvcmsuIEnCtG0gdGhpbmsg b24gMiBzdHJlYW1zIHdpdGggMTAgbGluZXMgdHVybmluZyBpbnRvIGEgc3RyZWFtIHdpdGggMjAg bGluZXMuDQpDb3JyZWN0IG1lIGlmIEkgYW0gd29ybmcsIGJ1dCByZWZlcmVuY2VzIGRvbsK0dCBh ZGQgbGluZXMgdG8gdGhlIHN0cmVhbS4NCkF0ZW5jaW9zYW1lbnRlLA0KQWxleA0KDQoJL...

Create a job sequence. Use a Notification Activity to send an email. Use the trigger on a preceding activity (for example the exit status of a Job Activity) to cause the Notification Activity to be invoked. Compile the job sequence then examine the code that is generated (Job properties, Job Control...

A UNION is the elimination of duplicates. Search the archives (www.dsxchange.com) for these terms. It is better, if possible, to form the UNION before the rows reach DataStage, because that was DataStage will have the smallest possible number of rows to process. _____________________________________...

DQpoaSwNCg0KY2FuIHlvdSBiZSBtb3JlIHNwZWVjaWZpYyA/DQp5b3UgY2FuIG1ha2UgYSBVTklP TiB1c2luZyBhIHN0cmVhbSBhbmQgYSByZWZlcmVuY2UgbGluaw0KDQpyZWdhcmRzDQpSdWkgU29h cmVzDQpTZW5pb3IgQ29uc3VsdGFudA0KLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4u Li4NCk5vdmFiYXNlDQpSdWkuU29hcmVzQE5vdmFiYXNlLnB0DQpUbG0gOiArMzUxIDk2I...

TWlzdGVycywNCmlzIGl0IHBvc3NpYmxlIHRvIG1ha2UgYSBVTklPTiBiZXR3ZWVuIHRvIHN0cmVh
bXM/DQpUa3MsDQpBbGV4DQo=

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

R3VpbGxlcm1vLA0KSSBub3RpY2UgdGhlIHdheSB5b3UgZGVmaW5lIGEgZnVuY3Rpb246DQogDQpE ZWZmdW4gRFNTZW5kTWFpbChBKTsNCg0KSSBjYW7CtHQgcnVuIGEgam9iIGNvbnRyb2wgaGVyZSB0 aGF0IGhhdmUgdGhpczoNCiANCkRlZmZ1biBVSGFzaExvb2t1cChBMSwgQTIsIEEzKSBDYWxsaW5n ICJEU1UuVXRpbGl0eUhhc2hMb29rdXAiDQpQX0RBVEFfSU5JQ0lBTCA9IFVIYXNoTG9va...