DSXchange

To use the function, what happens if you try it this way: GetEnvironment('envVAR') Note the quote marks around the variable name envVar; that is because, as Craig said, the function wants a string. You might want to read this as well; search is your friend. http://www.dsxchange.com/viewtopic.php?t=1...

An interesting idea; time for me to do some reading.
Thanks, Ray.

ray.wurlod wrote:DataStage schemas support variable vectors, and you can promote subrecords using a Promote Subrecord stage. Just an idea.

An interesting idea; time for me to do some reading.
Thanks, Ray.

ray.wurlod wrote:DataStage schemas support variable vectors, and you can promote subrecords using a Promote Subrecord stage. Just an idea.

It has been a while since I worked with cobol. As I recall, any single cobol field is fixed-width in nature. For example, X Varchar(10) vs. PIC Y(10) - X may present anywhere from 0 to 10 characters, but Y will always use 10 characters. note: it is hard to show spaces here, so I'm using period (.) i...

What is the source of your text file? It sounds like somebody typed out the data "incorrectly" e.g. instead of city="Vasco da Gama" they typed city="Vasco\tda\tGama" Can you persuade your data source to correct the issue? If not, what kumar_s said sounds good. You'll ne...

How many columns? And... you said, "We're creating the jobs and doing it manually..." Jobs? Why plural? I mean, how many jobs are you creating to move the data back into table_A ? How complex is your A->B transformer? You say mapping only - so no derived expression? No stage vars? Does tab...

There are some trouble shooting things we could do to dig into the data values, but the more I think about this I am actually surprised that it works with the Admin user but not the other user. If the only difference is simply that Admin user works ok, and other user doesn't work, then it has to be ...

Thanks for the quick reply. Do you mean to say that with ODBC connector we can connect to a remote m/c without actually using an ftp stage? Because the first activity to happen is to bring the file from that server to our server. Please clarify remote m/c = "remote machine" ? 1) what kind...

Dears, In the DataStage Engine Server, when I run some jobs to split data using administrator user, it goes smoothly with no problems. But, when I run it using another user, even with administrative privileges, the Arabic characters comes as garbage. Could you please investigate this Issue ... ? No...

The unmatched quote part caught my eye. Cannot find DataStage project directory. Unmatched quotation marks. Verb "/unixbox/ASCENTIAL/DATASTAGE/DSENGINE/.DSPROJECT " " is not in your VOC. Koti Possible that you have a typo on your path setup? It looks like there is a trailing quote on ...

I would suggest that your requirements are unclear. In your situation, I would push back on my requirements source and make them clarify what they mean by "integer". If you are talking about hardware supported integers (which is what technical people assume given the phrase "converted...

Yeah... as shown in the example, i will be incorporating all the partial key combinations. But i dont understand how do i specify to check for the availability of the partial replacement using lookup. The Key gives equality, range, etc as the Validation condition. How to make it check for partial e...

Couldn't you tell it you have no quotes and then trim only the leading and trailing quotes from the data? Yeah, I thought of that, too. It would work provided there are no embedded field delims. But if I'm reading the example right, some of the data will break that. This kind of data is expected fr...

You should look through some examples of logic other people have used. Lucky for you, this is a common problem. Hi, i have my input in below format column 1 2 ...etc... 9 10 the records are fixed number 10, i want to output 1|2|3|4|5|6|7|8|9|10 You might try searching on pivot . If you do that, you ...

Ahhh. I never thought to try looking for log details in the main entry point . That did the trick. Thank you, Craig. r.e. your interpretation, the red part nailed my symptom. The rest reminds me me how much I still have to learn. Thanks again! I know of no reason why RTI job logs would simply "...