DSXchange

Hi All, I have kind of XML questions with database..here is the scenario..I have XML...where Project is at higher level..in which i have sub nodes like tracking,companies etc..i can have multiple company for project etc..how i have to do my updates in my table is that...if a record that need to be u...

Hello,

Is there a method to handle like 5m.b of xml file ina folder stage and the xml input stage....or is there a way,...i tried using the longvarchar with maxmium length but it did not work...is there any NLS setup that i can use to make it work..Pls help me out....

Thanks,

Hi, I have new sql server database that need to be put so idid define the .odbc.ini file and uvodbc.config in the project flder..when i try to connect from the client i get this error DSR.MetaGeta(GET.DSNINFO)(SQLConnect('SQLDEV1','dwuser')): BCI Error: SQLSTATE=08001,CODE=11,[DataStage][SQL Client]...

Hi, I have to install the XML pack or the plugin in the maching can i know where i can find installs in the InformationServer installable files... I didn't the one who installed the product first...we need to do the xml plugin installs becasuse DS is throwing me an error when i use XML stages... th...

vinbhate wrote:Yes sachin...That was the good demo which you showed me of input XML stage.Thanks once again for your effort.

You should see some best practices by duke in his we site..you can follthis link and downlod the xmlbestpractices....
http://www.duke-consulting.com/DataStage_Tips.htm

Thanks,
RK

Hi, I have to install the XML pack or the plugin in the maching can i know where i can find installs in the InformationServer installable files... I didn't the one who installed the product first...we need to do the xml plugin installs becasuse DS is throwing me an error when i use XML stages... the...

RK, That's becasue you are behind the firewall. You need to open up your HTTP Proxy Server. Do i need to enable in my server...Pls advise whats need to be done.... Thanks, I solved th issue the reason being..the setup was not proper so we need do some lib path setting.. we added a new entry in our ...

ray.wurlod wrote:Because from the GUI the executing user is dsapi_server or dsapi_slave. ...

thanks ray.....

Did you specify authentication details (hostname, user ID and password) in the dsjob command? If not, try doing so and let us know if that works. ... i solved this issue by giving the same set of permissions as the user that was working..I don't understand why it gave error running job rather givin...

Error code 30107 means 'subroutine failed to complete successfully' as I'm sure you've found in searching the forum, and that doesn't help much in analyzing the cause without more information. If you ... I did serach the forum..before posting..the thing they do get some meaasges i don't...also i us...

Hi,

I ahev datastage job which fails to runn for a particular user...it is the group..also i can run the job from dirctor..i get an status code syaing 30107 erron running job..it doiecnot even kick off the job..pla help out...

OK, in spite of your tr not behaving like the man pages say it ought, try this: tr -d \x0 < #$FILEDIR#/#File#.ld > #$FILEDIR#/#File#_#Name#.ld If that doesn't work, try us ... at last it works..^@ works..i don't why the /x00 or /x0 did not work..i really appreciate Ray,chultte and Arndw for their v...

Try losing the hard quotes, and using the -d option. tr -d \x00 < #$FILEDIR#/#File#.ld > #$FILEDIR#/#File#_#Name#.ld ... Now the o/p of the command is for ex 12/09/2007-----output as 12/9/27...i don't know it is removing all the 0's rather than remvoing the hexa ctrl 00...is the reason is because a...

:? Post the exact command you are using and how you are executing it. Exact. Copy/paste the entire thing, not selective samples like you've done before and not what Arnd wrote - your command. cat #$FILEDIR#/#File#.ld | tr \ '\x00' \ '\' > #$FILEDIR#/#File#_#Name#.ld I did this command on after job ...

Are you executing tr as UNIX shell in the after-job? Also, what happens if you change your command to read: cat filename1.txt | tr \'\x00\' \'\' > filename2.txt ... It works with no error..but the output file got messed up it removed all the 00 from the file so for ex if the date field is there 200...