DSXchange

Can I call a job in DS Sequence with the warning limit set to 'No limit'. If yes, how.

Thanks

How do I handle files with DOS Line termination (CR LF) in Sequential File stage in a Parallel job. The Record delimiter in Format tab has only the following options :

Unix New Line
blank
null

Thanks.

I have a general question on Idoc Load stage. What is the parameter or key that determines the No. of idocs that get created.

Thanks.

Can we Convert a file from EBCDIC format to ASCII format with a design like this

Seq File with EBCDIC -> Seq File with ASCII

Also, do we need to specify 'Data Format = Binary' for the 'Seq File with EBCDIC'.


Thanks.

Hi,

I have a file from Mainframe with the following data types

DEC FIXED(5,2)
BIN FIXED(15)

I am using Sequential File stage with EBCDIC character set. What DataStage data types I will use for those above two data types.

Thanks.

So, what would be the timestamp for '0001-01-01 00:00:00' that would be accepted in SQL Server.

Thanks.

Hi, I am trying to load a Timestamp field into a table in SQL server database. It is giving error 'Date time overflow ...'. I checked the incoming timestamp value. It is like '0001-01-01 00:00:00'. However, I am able to load the field with CurrentTimestamp() value. Please let me know whether SQL ser...

For packed decimals,
can not we do that in seq file stage using format option for Decimal, Packed = yes and setting EBCDIC

Please let me know when the use of CFF is absolutely required and can not be done using Seq File stage.

I am trying to invoke a RFC enabled Function Module using BAPI stage.The input file contains about 22K records in Unicode format. The problem is the BAPI stage calls the Function Module and loads only the 1st record in the file and not the other subsequent records.

Please advise.

The problem is that I need to use the file as SAP BAPI Input and those strange characters are not accepted in BAPI stage.However BAPI stage expects input file in Unicode.

I am trying to generate a flat file in Unicode format.I made the following change in the Sequential file stage.

1. Set NLS Code page : UTF-16
2. Set char/varchar column extended property 'Unicode'.

But the file is generated with strange characters like this (when I view in Notepad)

I tried the following in the script TestFTP.sh:

#!/bin/sh
ftp -i -n <<EOF
open <Host>
user user1 pass1
lcd /dev/my_dir/
get "Data Rates.csv"
quit
EOF

In execute command, I tried

sh TestFTP.sh

I am trying to FTP (Get) from script in Execute Command stage. From FTP stage it works fine.With script I get following error : 'AUTH GSSAPI': command not understood 'AUTH KERBEROS_V4': command not understood KERBEROS_V4 rejected as an authentication type My DataStage server is on Linux box and am t...

I have called a remote Unix job from sitting on DS on Unix through 'Command activity' 'rsh. So, thought is there any similar things out there.