DSXchange

I am upgrading datastage from 7.5 to 11.5 and finding that 11.5 will not compile jobs that did compile in 7.5 . One problem is that many of my jobs are using the built-in routine DateTimeStampToOraOCI. If there is a space in the argument before the date it bombs, which it did not do in 7.5 So, is th...

Kryton,

thanks, this was the kind of push I was looking for.


Randy

the oracle tables will match each of the reports. so if report 1 has 3 columns of data, the oracle table for that report will have 3 columns to match. If it makes it easier, I would be willing to work with oracle hold tables where I load one line from the report into a holding table, and then use PL...

In the sample file below, I have 4 reports: SUMMARY CLOSING BALANCE SALES TRANSACTIONS SUMMARY REPORT RECONCILIATION REPORT OTHER SALES SUMMARY REPORT And I need to "load" reports 2 and 4 into separate Oracle tables. Thanks Randy 1 DATE RUN: 03/05/12 TIME : 14:29:36 SUMMARY CLOSING BALANCE...

Hi, I have a file that contains 10 reports. I only need to load 3 of the reports. The data in one report will start in a different column the the other reports. I kind of need alittle help just getting started. I assume I need a stage variable for the report header. When It equals a report I need so...

its an html report, so I need the stuff between <TR> <TD> and </TD> </TR>

Randy

I am trying to load an html report into an oracle table. I have looked at some of the xml documentation but not sure it applies to html reports. I tried to use the XML Meta Data Importer, but it hangs when I try to select an encoding. I am only getting the files twice a day and it only has around 10...

Our auditors want us to send invalid login attempts into DataStage to the syslog server. Does anyone know how this can be done?

chulett, shepli,

thanks so much for the help. I was really stuck.

Randy

If I have a stage variable like this:

If(lnkFTP.line_data[1,2]='70') Then lnkFTP.line_data[4,11] Else StageVar1

then some lines get the Label1, but the rest get 0's

Although I could still use a hint or two.

I agree about the 2 passes, but could not see the complete response.

I only saw the first 2 lines of your response, but I was having problems with the fact that the line the StageVar was reading was coming after the data.

My test file looks like this 123 234 07 "IMPORTANT LABEL 1' some totals 345 456 07 "IMPORTANT LABEL 2' some totals What I need to do, is put the IMPORTANT LABEL on each line of the data I load. The Label is always at the end of the data. The line with IMPORTANT LABEL always starts with '07...

I will mark this as closed, thank you very much.

Randy