DSXchange

Thanks Ray, I tried with SUPRESS HEADER option as you mentioned, but I'm receiving an error message, so I commented the SUPRESS COLUMN HEADING statement, so I tried with unix sed command and its working fine. Please let me know if SUPRESS statement is wrong. Ans=0 PathFileName = FileDir:'/':fvdsjobn...

Thanks Ray, It worked after I used convert function. Ans=0 PathFileName = FileDir:'/':FileName * OpenSeq File or Create File OpenSeq PathFileName To FileVar Else Create FileVar Else Abort fvFilterDate = fvdate * Set the Terminal Width wide to show more characters Call DSExecute('UV','TERM 170',rVal,...

Hi, Sorry its my mistake I removed comment from the below statement *cmd := \ GROUP BY INSTANCE, CREATOR, MODIFIER\ but I'm facing an new issue Run-time error '-2147417848 (80010108)': Automation error The object invoked has disconnected from its clients. New Code: Ans = "" DataBack = '' C...

Hi All, I have a server routine to get the auditing information like job name, creator and modifer name and last last modified timestamp for a particular date. I'm using below Transform function. But I'm getting an error message DataStage/SQL: Individual column specifications are illegal with a sing...

Hi, In 8.7 version, I found couple of files with encrypt.bat in documentation install_root\InformationServer\ASBNode\bin\encrypt.bat install_root\InformationServer\ASBServer\bin\encrypt.bat When I checked in my local drive using 8.5 version under C:\IBM\InformationServer\ASBNode\bin, I'm not able to...

Hi , I'm using dscmdimport.exe command to import the datastage jobs and below is the parameter that is setting up the datastage credentials SET DParams= /D=%HostName% /H=%ServerName% /U=%userid% /P=%password% %project% My question is, is there a way to pass the encrypted password for the P parameter...

Thanks Ray for the help. It's working after using single quotes instead of double quotes for literals........

Hi All, I'm trying to find the category name for a particular job by a transformer function. Below is the code Ans = "" svName = "pxHtttlemp" svTrimName = Trim (svName,".","A") svFMName = Trim (svTrimName,@FM,"A") *Get list of jobids that contains a ...

Hi Ernie, The problem is with the data type that I used when I imported the meta data from XML Table definitions, for numeric fields like PHONE Number it imported as decimal (10), I changed to varchar (10) and made the Key column as Phone type code and I'm getting all the record's with out any dropp...

Hi Ernie, Thanks for the reply. Here is the issue is not with repeating element, but this issue is due to repeating sequence in XML. I tried making PHONE_TYPE_CODE as a key column with repetition element required option selected . But still getting the same issue only getting one record. I think I n...

Hi, I'm working on XML file that has the repeating sequence. Please see below <?xml version="1.0" encoding="UTF-8"?> <MEMBER_EXTRACT> <REC_CNT>1</REC_CNT> <MEMBER> <MEMBER_ID>111</MEMBER_ID> <MEMBER_PHONE> <PHONE_TYPE_CODE>WORK</PHONE_TYPE_CODE> <PHONE_TYPE_DESC>Work/Office</PHON...

Thanks Chullet. But the command is only inmporting executables is there any unix tools available to import datastage jobs including executables


Thanks,
Raju

I'm trying to invoke dssh shell from the command prompt and I'm getting below messages. bash-3.2$ This directory is not set up for DataStage. -bash: This: command not found -bash-3.2$ Would you like to set it up (Y/N)? 0. Ideal compatibility 1. IN2 compatibility 2. Prime Information compatibility 3....

After making the corrections as Ray mentioned it is working

I'm getting current job name and I need to get the proper output from DSGetLinkInfo function, even if the job handling section is wrong since the if clause will not be executed and goes directly to DSGetLinkInfo function, but it is always throwing -1 output . I don't think it is happening due to bad...