DSXchange

It's UDB database. The only change in my stage I make is the table name itself.

I'm having problem with selecting data using ODBC stage when the table name has _ in the name. I'm OK when the name is without the _. For example when I select #schema#.lpb - I get the data, but when I select #schema#.apl_policy - then I get following error main_program: Could not check all operator...

I believe the complex file stage doesn't take the schema as a parm.

Hi Everyone, what I'm trying to do Ftp a Mainframe file to a Binary file on the mid-range (contains packed data) Use datastage a datastage job that has the file name and Schema as a parameter that will translate the file properly to ASCII (including Packed) Any Ideas on the best approach? The key is...

Hi All, is it possible to use the DB2 with a schema file on the sequential stage to dynamically extract from DB2 and store to a file


DB2 ---> Sequential File


For example the SQL would be dynamic and passed as a PARM to the DB2 Stage

Im generating an xml and was working fine and after adding more columns in the transformer stage (constant value tags). Its aborting with the following error msg:

dataset --> transformer --> XmloutputPx

APT_CombinedOperatorController,0: Operator terminated abnormally: received signal SIGSEGV

eostic wrote:That's an error I haven't seen before in relation to XMLOutput..... Can we assume that your SQL data type is char/varchar/longvarchar ?

Ernie

Im using VARBINARY data type and XML as data element for the xml chunk data.

I dont have XSD for my output xml file.
I am getting following error when trying to assign "XML" as data Element to my xml chunk. So that i can join it with main xml. Do i need to create XSD for xml ?

"the data element selected is not compatible with sql data type."

Want to create dynamic tags in a xml: following is the table to pickup the data: Keytag Maintag Subtag Value -------- --------- ------ ----- PC A X 1 PC B X 4 KB B X 6 HD A X 2 HD B X 7 Desired Result (xml): -------------------------- <PC><A><X>1</X></A><B><X>4</X></B></PC> <KB><B><X>6</X></B></KB> ...

Hi All, I'm reading a sequential file into a transformer stage and want to to special processing on the last row. Is there an easy way to determine the last row in the file? I was thinking of just marking the last row with a flag before reading. Is there an easier way?

Hi All, how do I get datastage to output apostrosphe ' instead of &apos; in my XML output. For example I want St john's but data stage is outputting
St John&apos;s . Is there a way to override it?



Thanks

Hi all, i have encountered a problem where i'm extracting a birthdate from the db2 mainframe to UDB and datastage is adding 1 day to the date

I also wrote directly from aminframe db2 to a PEEK stage with the same result

I know the Unix start date is 1970-01-01. has anyone else run into this problem?

Hi all, I am recieving the following error after running an FTP stage, grabbing data from a fixed width (80) file on mainframe, and writing to a sequential file: ftpCPCtest..Sequential_File_1.IDENT1: Mismatch in number of column between data and link I have adjusted my length/display in my FTP stage...

Actually, to get more to the point....

1) does anyone know how to write to result of 'dir' or 'ls' to a file from Dos FTP.

or alternatively,

2) how to check if a file exists on mainframe from datastage

Any help or info on where to find some help would be greatly appreciated.

Cheers,
Adam

Ya ls is supported. So I'm thinking... ls and put that list into a file, exit ftp, and run dos to real file line by line looking for my file name. If present do something else. This sound like a good plan?